Subform Question

  • Thread starter Thread starter TH
  • Start date Start date
T

TH

Hi,

How do you get a combo box in a subform to show an updated list of what's in
the field? I have a person selecting a value from the combo box (of course)
and when the item they want to enter is not on the list they click a combo
button and enter the desired item on a pop form. When the person is done
entering the information, I want the subform to reflect the change (the new
item they entered). Any help would be appreciated.

Thanks

Tonye
 
I assume that the code that runs when you click the button opens the popup
form using a command similar to this:
DoCmd.OpenForm "popupformname", , , , , acDialog

If so, add the following step (substitute your actual name for the combo
box) right after the above code step:
Me.comboboxname.Requery
 
Hi,

Thanks for responding. I've never worked with code. Is there an easy way
to start learning or is there another way to do this? Thanks.

Tonye
 
I usually use macros.

Tonye

TH said:
Hi,

Thanks for responding. I've never worked with code. Is there an easy way
to start learning or is there another way to do this? Thanks.

Tonye
Click to expand...
 
Macros can be used to do what I've written in the VBA code example.

For DoCmd.OpenForm, you use the OpenForm macro action. For the
Me.controlname.Requery, you use the Requery macro action.

How are you opening the popup form now?
 
Back
Top