trouble populating txtbox & tble field aftr selecting value from c

G

Guest

I have a form that is linked to several tables. The form is used to create
an invoice record in a table called Invoices.

There is a section where I select parts that are being purchased. There are
many combo boxes each getting its values from a field called Part # in a
table called Parts.

When I select part #'s I want several things to happen, but I'm having
trouble getting all but one to work. This is what I want to happen:

1. The selected Part # gets stored in a field called Part # in the Invoice
table.
This works because I made the control source equal to that field in the
Invoice table.

2. I want the Part Description (obtained from the Parts table) of the
selected Part # to populate a text box on the form.

3. I want the Description to get stored in the Description field of the
Invoice table.

4. I want the same thing to happen for Part Price and Part weight.

I can only get 1. to work. I appreciate any help.

Thanks,
Anthony
 
G

Guest

It look like your trying this to get tis to work from a continous form. That
way it isn't going to work.

If it is going to be used in a continious form you have to create the
combo's in the detailsection of the form where the controlsource = field
which you want to fill and the rowsource of the combo = the table where the
values are coming from.

hth
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top