Access Database

[lynmoo]

I have created a form where data is entered and added to a table. In order
to edit the data I created an edit form. On the 1st form where the data is
entered there is one field that has a drop down list to choose from.

How can I also have a drop down on the edit form and insert the new data to
the table? I created a pop up form with the list to choose from when the
field is chosen on the edit form. I do not know how to write a macro or
whatever to have the choice insert in the field on the form and update the
table. I am new to macros.

 

[Jeanette Cunningham]

lynmoo,
usually you can use the same form to add new data and also edit data.
On the form's property dialog on the Data tab
--> Allow Additions - set to Yes
--> Data Entry - set to No


Jeanette Cunningham -- Melbourne Victoria Australia