Coding Help 1

[cbearden]

I'm pretty much knowledge-less when it comes to programming. I was wondering if anyone could give me a tip or something on this problem I have

I based a form on a query. The query contains two tables(Acct, Dlr), which are related by one field called DlrNum(combobox). On the form, I have the DlrNum control based on the Acct table but the row source is the Dlr table. When someone types in a value that is not in the table, it needs to add that number to the Dlr table as well as all the fields that are in the dealer table:

ex:

#: 123
phone: 258-598-5555
contact: bob

I had been directed in the way of the OnNotInList event, but I don't know how to code it.

Thanks for the help

 

[PHV]

Have a look here:

http://www.tek-tips.com/faqs.cfm?fid=4283

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[cbearden]

It did. THanks!