By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,773 Members | 1,300 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,773 IT Pros & Developers. It's quick & easy.

Tranfer Data from Combobox lookup to new record in another table

P: n/a
2- Tables Customer & Invoice
Customer has typical ID,Name, street, etc
Invoice is special type has about 29 fields and needs to import the id,
name, street, etc to this table. Save the total data..
When the record is complete it will print onto a specialized multipart
invoice.
I setup a form for the invoice and lookup customer id, -- Now I need to
transfer the data from the lookup to fields in the invoice table..
I can supply copies of the files if you need to see them..
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies

P: n/a
Is your customer information subject to frequent change? If not, simply
include a foreign key to the Customer table, and pick up the information
with a Query when you need to use it.

If it is subject to frequent change and needs to be saved "as of this point
in time", include controls on the form bound to the fields into which it
must be saved, and set them in VBA code in the AfterUpdate event of the
Combo Box. These fields can, if you wish, have their Visible property set to
No, or can be left Visible to allow the user to see exactly what is going to
be saved.

Larry Linson
Microsoft Access MVP

"JC Mugs" <jc****@hotmail.com> wrote in message
news:vv***********@corp.supernews.com...
2- Tables Customer & Invoice
Customer has typical ID,Name, street, etc
Invoice is special type has about 29 fields and needs to import the id, name, street, etc to this table. Save the total data..
When the record is complete it will print onto a specialized multipart
invoice.
I setup a form for the invoice and lookup customer id, -- Now I need to
transfer the data from the lookup to fields in the invoice table..
I can supply copies of the files if you need to see them..

Nov 12 '05 #2

P: n/a
"JC Mugs" <jc****@hotmail.com> wrote in message
news:vv***********@corp.supernews.com...
2- Tables Customer & Invoice
Customer has typical ID,Name, street, etc
Invoice is special type has about 29 fields and needs to import the id, name, street...


No it doesn't. It needs to link to Customer. In your Invoice table design
insert a field called CustomerID, or somesuch. In the relationships window
of Access create a one to many join from Customer to Invoice.

Then do a query to give you the information you need.

YOurs, Mike MacSween
Nov 12 '05 #3

P: n/a
Beg your pardon. Larry's right. If you want to store 'where this customer
was when this invoice was raised' then you'll have to do it as per his 2nd
paragraph.

Mike

"Larry Linson" <bo*****@localhost.not> wrote in message
news:c5*******************@nwrddc02.gnilink.net...
Is your customer information subject to frequent change? If not, simply
include a foreign key to the Customer table, and pick up the information
with a Query when you need to use it.

If it is subject to frequent change and needs to be saved "as of this point in time", include controls on the form bound to the fields into which it
must be saved, and set them in VBA code in the AfterUpdate event of the
Combo Box. These fields can, if you wish, have their Visible property set to No, or can be left Visible to allow the user to see exactly what is going to be saved.

Larry Linson
Microsoft Access MVP

"JC Mugs" <jc****@hotmail.com> wrote in message
news:vv***********@corp.supernews.com...
2- Tables Customer & Invoice
Customer has typical ID,Name, street, etc
Invoice is special type has about 29 fields and needs to import the

id,
name, street, etc to this table. Save the total data..
When the record is complete it will print onto a specialized multipart invoice.
I setup a form for the invoice and lookup customer id, -- Now I need to
transfer the data from the lookup to fields in the invoice table..
I can supply copies of the files if you need to see them..


Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.