i would like to have a form that adds new records and .........

[gnibbles]

I hav a form that adds new bills and I have all of the text boxes but what I need to do is have one drop down box that updates data in the bill table and also finds corresponding data and puts them into their appropriate fields. I have tried using the wizard but all that does is search within the table and doesnt add new data just updates old fields. I want to get external data from other tables and insert them into the new table  through one drop down box. I dont know if this is very clear.

 

[JimConrad]

Sorry, but it isn't clear to me what you are trying to do. <p>Jim Conrad<br><a href=mailto:JimConrad@Consultant.com>JimConrad@Consultant.com</a><br><a href= > </a><br>

 

[gnibbles]

I want to be able to have a drop down box and select a value from a table with it and when that is done other values from other fields will display. But I'm inserting this data into another table via a form for that table.