show related field on a form during data entry

  • Thread starter Thread starter Tom Wesley
  • Start date Start date
T

Tom Wesley

Hi all,

I'm very new to Access itself, but have used another database system
called Equinox for Windows (www.compsoft.co.uk) so know a bit about what
I'm trying to achieve.

I have a sales order processing database with just two tables, ORDER,
COMPANY, with a CompanyRef as the key in COMPANY.

I have a form for the ORDER table, but haven't found a to show fields from
the COMPANY table during data entry. For example, after entering the
CompanyRef, the address and company names would appear on screen for the
user to verify. Note that I do not want these fields to be editable, as
they reside in a different table.

Is there an easy way to do this that I have missed, or am I better
sticking with the little-known Equinox?

Also, could you please cc my email account, as I'm a little rushed here
and would appreciate reading any reply as soon as it gets posted.

Cheers in advance,
Tom
 
use a combo box for the user to enter the Company Ref, if you're not already
doing so. add all the fields you want to show on the form to the combo box's
RowSource (which should be either a query or a Select statement). to hide
those "extra" fields in the droplist, set their column widths to 0".
okay, now you have all the data you need, available in the form. you can
display it whereever you choose, by using one or more unbound text boxes
with the ControlSource as
=ComboBoxName.Column(1)
or column 2 or 3 or whatever. fyi, combo box columns in Access are
zero-based, so the first column is 0, the second is 1, etc.

hth
 
I would use the Customer data on the main form and the orders data on a
subform. So you can navigate thru the customers and enter orders as needed.
The linking criteria would be the customer ID.

HTH
Damon
 
use a combo box for the user to enter the Company Ref, if you're not already
doing so. add all the fields you want to show on the form to the combo box's
RowSource (which should be either a query or a Select statement). to hide
those "extra" fields in the droplist, set their column widths to 0".
okay, now you have all the data you need, available in the form. you can
display it whereever you choose, by using one or more unbound text boxes
with the ControlSource as
=ComboBoxName.Column(1)
or column 2 or 3 or whatever. fyi, combo box columns in Access are
zero-based, so the first column is 0, the second is 1, etc.

hth

Sounds like a plan to me. I'll post back if I have any problems.

Cheers,
Tom
 
Back
Top