update a record with selections

[Accessnewbie83]

hi, I am pretty new to access, and am building my first big db, I have managed to figure out almost everything I want to achieve however there is one thing that I just cant get:

I have two tables one with customer details and one with item details, when an order is placed I want to put the customer ID against that item.

I have a main form that is used to select a customer and will show all their outstanding orders, from that I have a pop up form that allows me to add a new item to their account. But the problem is that in this pop up form I have three combo boxes which are used to filter and select the specific item (each item has a unique ID) I can get this form to display all the info ie the item ID and customer ID but I cannot get the customer ID to save against that item ID in the item table.

Hopefully one of you gurus out that can help me with this, as I say I am fairly new to Access and my db is probably not build particularly well but I have managed to make it do everything I want so far.

Thanks in advance for any help.

 

[binbin]

I'm not a guru, as you can see, fairly new to the forum but will try and give you some inputs.

Why do you need a pop up form? Why not use a subform in datasheet view to add line items filtered by the comboboxes? Sorry, I'm not familiar with how you want an item be connected to a customer. But it does seem like item details will be in a subform.

Maybe posting a cut-up (sensitive data removed) version of your database will give the community a better picture of what you want to do. Compact and repair your database, publish to 2003 .mdb file then add to zip file.