My database has two tables CR Detail Log that holds events and CR Policy Cert Info that holds customer demographics. I have built a search & edit function with a prompt to enter the customer number and it populates a replica of the data entry form. There is a control button that has a pop up form that I cannot get to populate. The main and subforms to populate. The form is listed as Search SubForm Accommodation Pop Up All. The table that contains this data is in the CR Detail Log. The queries I am using for this form is CR Detail Log Table to pull the data from the table and qryAccommodation Search which is attached to a Macro named Accommodation Form Search Macro.
I have attached the database. Can anyone suggest a way to get the data to populate?
Thanks in advance for any help you can provide!
I have attached the database. Can anyone suggest a way to get the data to populate?
Thanks in advance for any help you can provide!