Combo not showing value

  • Thread starter Thread starter CJ
  • Start date Start date
C

CJ

Hi:

My form (frmQuotes) is based on a table (tblQuotes). In the table I have a
lookup for lngBillingID which allows me to find the correct billing address
for a quote. I have a command button that opens the frmBilling when
necessary

On my form, the lngBillingID combo does not update after I add a related
record to the frmBilling. The value is availabe in the combo box, but only
after you select it with the drop down arrow. Also, the value of the
lngBillingID is not added to the tblQuotes record until I physically select
the number from the combo box. I would like the lngBillingID to show up in
the frmQuotes field immediately after I close the frmBilling.

I have tried requery, I have tried set value, but I must be still missing
something.

Any ideas?

Thanks
 
Never, mind........I revisited my relationships and corrected an error. Then
accomplished what I wanted with a Visible/Invisible subform.
 
Back
Top