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

Load data into new record using form controls (2007)?

P: n/a
Hi,

I'm an ex-Notes guy, doing an Access 2007 project. I'm a little weak
on Access syntax and functionality. It's not a customer database, but
it will be easier to describe it in those terms...

I have a form for creating/viewing purchase records.

When creating a new purchase record, I would like to use a combo box
on that form to select the desired CUNO from the customer table. Once
this is selected I would like the form to load a few fields from the
customer table into the matching fields in purchase record table (and
display these on the form).

Is there reasonably simple functionality to do this kind of thing? I
can't find it in the book.


Thanks :O)

Jun 1 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
The Northwind sample database that installs with Access will give you an
example to follow.

Open the Orders form in design view, and see how the AfterUpdate event of
the CustomerID combo copies the address fields as the default address for
that order.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

<ri*********@yahoo.comwrote in message
news:11**********************@g37g2000prf.googlegr oups.com...
Hi,

I'm an ex-Notes guy, doing an Access 2007 project. I'm a little weak
on Access syntax and functionality. It's not a customer database, but
it will be easier to describe it in those terms...

I have a form for creating/viewing purchase records.

When creating a new purchase record, I would like to use a combo box
on that form to select the desired CUNO from the customer table. Once
this is selected I would like the form to load a few fields from the
customer table into the matching fields in purchase record table (and
display these on the form).

Is there reasonably simple functionality to do this kind of thing? I
can't find it in the book.

Thanks :O)
Jun 2 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.