Form to update a record...

[Oyster]

I have a form that is populated by a query. Once this data is retrieved, I'd like to be able to make changes in order to update the record on the table.
Can this be done?

 

[trucktime]

Update

Of course, if the form you're using is bound all changes will be saved in the table
as soon as you close the form, or go to a different or new record.
Just go to the record you need, change data in the fields, and that's it.

 

[Oyster]

Don't think this will work because the form is not tied to a table. It's tied to a query. You can't make changes to any of the fields.

Thanks

 

[Mile-O]

You can't make changes to any of the fields.

Why not?

 

[Oyster]

I really don't know. I guess I should ask: What would prevent data on a form from being changed? If I move my cursor into a box with data, I can't do anything.

Thanks

 

[Mile-O]

The textbox may have both its Locked and Enabled properties set to Yes.

The query bound to the form may be a non-updateable recordset - typically due to too many tables involved in the query.

 

[Oyster]

I found the problem. If it was a snake, it would have bit me!
I was using a macro to open the form. Within the macro I was opening the form in read-only mode. I changed this to Edit. Now its working!

Thank you for your quick response!