Form based on table is not populating

**alansidman** · 04-25-2011, 10:11 AM

Ok. More thinking outside the box. Add an after update event to each of the four text boxes. In the after update event put the same code used in the on load event to lock the text boxes.

So, when the form loads, the text boxes are locked. Click on the command button and you can edit any text box. Click on a tab or enter and the after update event fires and re-locks all the text boxes.

Its a workaround that just may work.

Alan

**vampyr07au** · 04-25-2011, 10:27 AM

Originally Posted by alansidman

Ok. More thinking outside the box. Add an after update event to each of the four text boxes. In the after update event put the same code used in the on load event to lock the text boxes.

So, when the form loads, the text boxes are locked. Click on the command button and you can edit any text box. Click on a tab or enter and the after update event fires and re-locks all the text boxes.

Its a workaround that just may work.

Alan

Thanks Alan,
It is a kind of workaround. It does work however the only thing wrong with it is that for me to actually edit an entire movie record (read line) I need to click the edit button each time I change the focus to the new text box.

What about a way to use the command button to open a new form with only that lines entries in it .... the form would look just like the search form already created but pre-populate with the relevant entry ?

**alansidman** · 04-25-2011, 10:32 AM

Create a form that has a record source the query that you developed for the search. Its worth a try. You could have it open as datasheet view. Make your edits and close it.

This also reminds me that if you run a query, you can make edits directly in the datasheet view of the query and it will update your table. Pick your poison.

Alan