Inheriting data from combo box

[wllsth]

I have a field 'Customer Name' on my form 'EstimatesNew' and I retrieve records from my Customer Table to autofill my form. If I wish to create a NEW customer it pops up with a new Customer Details Form. However it doesnt inherit the Data I've inserted in the original field on my main form. What am I doing wrong ??

Sample DB is attached

 

[jzwp22]

I didn't see an attachment to your post.

 

[Scooterbug]

Gonna go out out on a limb here....

Sounds like you might have to requery the combo box. Once you do that, then the new customer that you put in will show up in your combo box.

 

[wllsth]

Thanks I have resolved the problem. I had some duff code in there which I picked up by mistake.

 

[jzwp22]

Glad to hear that you got it worked out. Good luck with the project.