RE: PLEASE HELP! creating fields on a form that autopopulate

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have the following:
T_Orders
T_OrderDetails
Q_Orders
Q_OrdersDetailsExtended
F_PurchaseOrder
Subform for F_PurchaseOrder is F_OrderDetails

F_CoreInformation

I now have the F_PurchaseOrder that lists my main purchase order info: i.e.
PO#, Shipping, Order Date, Vendor, etc.

My subform lists all the detail info of my purchase order: i.e.
nomenclature, part number, qty, serial number (if applicable), Unit cost,
Core Return required, and warranty info.

My Core Return is now a check box (I had a yes/no, but after rereading
Allenbrowne.com again, chose to go with just a check box) If the check box is
activated, a core return is required. When I click to activate this
checkbox, I have an event procedure, using a macro, to open
F_CoreInformation. This is now working fine. Everything is being saved in
the queries and tables as it should.

On my F_CoreInformation form, it lists the following fields:

OrderID
Core ID
Nomenclature
PartNumber
Serial number
Vendor
Return date
Shipping

Most of this information required on the F_CoreInformation is listed in the
F_PurchaseOrder & F_OrderDetails. When I activate the core return check box
and the F_CoreInformation opens up, I would like the basic info to auto
populate the F_CoreInformation . Then, I can manually enter the remaining
information that applies as it becomes available. For instance, the core may
not be returned for 2-3 weeks. I need to be able to come back and complete
the rest of the form at a later date. Does this make sense and can it be
done. If so how do I do it?

I have read the various posts about autopopulate and the suggested website
offered below, but I am not sure if I can autopopulate off the info from the
Main form and the subform.

Thank you





"Susan" wrote:

Hello, I have a database that I must run reports from. The problem is the
personnal at times are entering the wrong data. I would like to set up the
form to auto populate fields once a salesperson ID code is entered. Once the
ID code is entered I would like the salespersons name and location to
autopopulate into two seperate fields. How can I do this? Any suggestions
would be welcome.
.

Relevant Pages

  • Autopopulate multiple fields from main/sub forms
    ... I now have the F_PurchaseOrder that lists my main purchase order info: ... My subform lists all the detail info of my purchase order: ... Core Return required, and warranty info. ...
    (microsoft.public.access.forms)
  • Re: Autopopulate second form
    ... I need to be able to track these core returns on a seperate form. ... I now have the F_PurchaseOrder that lists my main purchase order info: ... and the F_CoreInformation opens up, I would like the basic info to auto ...
    (microsoft.public.access.macros)
  • Re: Autopopulate second form
    ... I now have the F_PurchaseOrder that lists my main purchase order info: ... Core Return required, and warranty info. ... and the F_CoreInformation opens up, I would like the basic info to auto ...
    (microsoft.public.access.macros)
  • Autopopulate second form
    ... under Macros. ... I now have the F_PurchaseOrder that lists my main purchase order info: ... Core Return required, and warranty info. ...
    (microsoft.public.access.macros)
  • Re: [PATCH/RFC] SPI core: turn transfers to be linked list
    ... the patch attached changes the way transfers are chained in the SPI core. ... they are turned into linked lists instead of array. ... The array may be of any size thus we can't divide the page into regions of the same size: we can't predict what the maximum size will be. ... technique for both message structure and transfer structure The problem with the current code is that transfers are represnted as an array so it can be of any size effectively. ...
    (Linux-Kernel)