Subform is not refreshing/updating new information from a combobox

socio81

New member
Local time
Yesterday, 21:43
Joined
Jul 17, 2013
Messages
2
I have a mainform in access with a subform (continous form mode). The subform's source is a query that has a criteria parameter that gets the values from a combobox in mainform.(list of projects) Combobox name= cmbProject

It works fine for some records (old records), so when I migrate new data into the table the comboxbox display the new data but when I select the record to be dispayed on the subform, the record or data is not in the subform, so the record is in blank.

Can you help?
if it's something to apply requery method? or any other solution ?
thanks!
 
It sounds like your saying the subform is changing when you select something from your combobox so I'm not guessing you need a requery. My guess is the query used for your subform actually does not contain the comboboxes selection. This 'new data' might be missing the field the combobox is selecting.
 

Users who are viewing this thread

Back
Top Bottom