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

[rickair7777]

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)

[Allen Browne]

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)