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

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.

<rickair7777@xxxxxxxxx> wrote in message
news:1180724174.878419.310230@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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)

.

Relevant Pages

  • Re: Creating a New Record for Another Form
    ... the client is a combo box; ... Orders form, the new customer isn't visible; ... Is there a way to automate that "requery" and drop that new Customer right ...
    (microsoft.public.access.formscoding)
  • Re: DoCmd and ListBox events
    ... the customer is chosen, I want to set the default value for one of the fields ... in the order details subform. ... I have two buttons on the orders form for going to the next and previous ... even though the ListBox is getting updated correctly when ...
    (microsoft.public.access.modulesdaovba)
  • Re: Form #1 that filters form #2
    ... I an not understanding what you are asking. ... customer table and the orders form comes from the orders table. ... customer form I asked it to filter by customerID in the command wizard. ...
    (microsoft.public.access.forms)
  • Re: DoCmd and ListBox events
    ... Allen Browne - Microsoft MVP. ... the customer is chosen, I want to set the default value for one of the ... in the order details subform. ... I have two buttons on the orders form for going to the next and previous ...
    (microsoft.public.access.modulesdaovba)
  • Re: Query Problems
    ... Is there any chance that a customer could buy more than one product at once? ... you need a structure very similar the the example in the Northwind sample database that installs with Access. ... This gives you a graphical example of how to create the tables for customers, products, orders, and order details ... Tips for Access users - http://allenbrowne.com/tips.html ...
    (microsoft.public.access.queries)