How to make changes to form/subform datasheet view.

[ittechguy]

I've created a form which allows users to add new records to tblCustomer. It is also used to filter records from tblCustomer using a subform and a search form in the footer of the main form. It can also be used to remove records by right clicking on the record in the subform and clicking delete. The form looks like this:





Currently, I have no way of making changes to records. I need to be able to make changes such as updating rank, shop name, phone number, etc. Most of those fields come from other tables and not from tblCustomer (to break apart the data and eliminate duplicate data).

I've tried using a combo box in the subform, but that won't work because it updates all of the combo boxes for that field. I've heard there are ways around this but they're complex. What would I do to get around that?

Another idea I had was to have a popup form that displayed customer's info and allowed the user to make changes. I would prefer if it could be done in the subform.

[June7]

Normally a form can be used to do data entry/edit for only one table. If you need to edit data of lookup tables, need to open a form to accomplish that.

[ittechguy]

Thanks for the reply. I think then I need to create a popup form that allows users to edit records displayed in the subform. My biggest problem is likely to create a way for the user to easily know which customer they're editing. I do not want to have to create another search form within the popup form to search for a customer.

I think the best way to do this would be to make it so that when a user clicks on a record (or cell) from the subform, a form would popup to edit that record. Is that a possibility?

[ittechguy]

Nvm, I figured it out. Thanks for your help.