Form with combo box and search field

[trenttc]

I have a form with a combo box that allows users to choose a specific catalog name (table1.id matches to table2.id, get table2.catalogname). Easy enough. But now I want that value to persist (once chosen) while also having a search box based on sku (table1.sku) that also returns the page number (table1.pagenumber) related to that sku. The page number field will be updated. Summing it up: choose a catalog and then repeatedly enter sku values and update their page numbers. I'm using Access 2007.

 

[Hmadyson]

Are your fields bound to the data? If they are, the values will persist for that record in the form. If you are dealing with unbound forms, then once a value is chosen it should persist until you do something to remove the value like close the form, or use code to clear it out.

Sounds like with the skus you will want to use a subform to store the information that is added. To do this, you will want to write an append query to add the new value to your table, and then use the requery method to update the subform. Possibly I am not interpreting your question correctly.

Please let me know if I can provide more assistance.