Is there a way to make changes to a table being used by an open form?

[Bkenney228]

I am trying to update a table (via a make table query) that is being used as the record source on an open form. Is it possible to update / change the data in a table that is currently being accessed by a form?

Thanks

 

[Darrylles]

Hi Bk,

Yes, as long as that particular record has not been edited without being stored by the form at that point.

However, you state that you want to use a maketable query? You are not then simply making changes to data, but to the whole table (which I would think would not be possible).

ATB

Darrylle



Never argue with an idiot, he'll bring you down to his level - then beat you with experience.