Edit a forms recordsource, when its based on 2 tables

  • Thread starter Thread starter James P
  • Start date Start date
J

James P

When a forms recordsource is looking at two table to get
its data, I can't edit the data on the form.

Does anyone know a way around this?
 
Hi James,

You have probably done something to make the query a read only query. You
can research this problem by looking at help - using the following search
criteria -

Online help - in Answer wizard type the following:
"When can I update data from a query?" - open the article by the same name.

Or look at this KB article:

ACC2000: How to Edit Records in Related Tables in a Microsoft Access
Database
http://support.microsoft.com/default.aspx?scid=kb;en-us;304474
 
Back
Top