Fields not updating? Access 2007

[Art W.]

Hello Everyone:

I have fields that are not updating if you look at the form “Lease” there is information in the fields that corresponds to the other tables. But when I go to the lease table I am only getting two fields the ones I selected. Not the ones linked to other tables.

What am I missing?

See attached file.

Art W.

[Davadvice]

hi,

I would say that you should describe how you are interacting with the data. Bound forms or are you using VBA. i'm not keen on opening a DB file i got from the net incase it has some nasties. please don't take the above as a slate on you as it is not.

if you are using bound forms, are they bound to a query ? if so make sure the RS is not read only. if you are using VBA then make sure that there is no paramiter missing on the query and test the append in debug mode as access can be a bit iffy when executing an append at runtime.

Thanks
David

[BillBoeBaggins]

So you have fields on your form that are not updating.
Update via... code or is the form handling it?

Three causes I can think of.
1. Your not triggering an update
2. Your data validates a rule
3. Your data source is a join query that is un-updateable