filling unbound fields according to combobox value

  • Thread starter Thread starter Ran BD
  • Start date Start date
R

Ran BD

Hi guys,
I have a table called cartbl contains different information on the car.
among are the car registration number, make and model (stored on fields
accordingly)
on a contract form I've created a combo box bound to the registration
number in the car tbl.
I want the make and model fields to be field automatically when the user
selects the registration number.

how do I do that ?

thanks
 
Ran BD said:
Hi guys,
I have a table called cartbl contains different information on the car.
among are the car registration number, make and model (stored on fields
accordingly)
on a contract form I've created a combo box bound to the registration
number in the car tbl.
I want the make and model fields to be field automatically when the user
selects the registration number.
Click to expand...


Add those other fields as additional columns to your ComboBox (hidden if you
like) and then use a ControlSource on your unbound TextBoxes similar to...

=[RegistrationNumber].Column(1)
=[RegistrationNumber].Column(2)

The TextBoxes will then *display, but not store* these other two pieces of
information depending on the registration number currently displayed in the
CommboBox.
 
access will not accept the format:
=[RegistrationNumber].Column(2)

and will change it to
=[Reg_num].[Column](2)
which will then produce #name in the unbound field.

any suggestions ?

Rick Brandt said:
Ran BD said:
Hi guys,
I have a table called cartbl contains different information on the car.
among are the car registration number, make and model (stored on fields
accordingly)
on a contract form I've created a combo box bound to the registration
number in the car tbl.
I want the make and model fields to be field automatically when the user
selects the registration number.
Click to expand...


Add those other fields as additional columns to your ComboBox (hidden if you
like) and then use a ControlSource on your unbound TextBoxes similar to...

=[RegistrationNumber].Column(1)
=[RegistrationNumber].Column(2)

The TextBoxes will then *display, but not store* these other two pieces of
information depending on the registration number currently displayed in the
CommboBox.
Click to expand...
 
thanks I found my error

Rick Brandt said:
Ran BD said:
Hi guys,
I have a table called cartbl contains different information on the car.
among are the car registration number, make and model (stored on fields
accordingly)
on a contract form I've created a combo box bound to the registration
number in the car tbl.
I want the make and model fields to be field automatically when the user
selects the registration number.
Click to expand...


Add those other fields as additional columns to your ComboBox (hidden if you
like) and then use a ControlSource on your unbound TextBoxes similar to...

=[RegistrationNumber].Column(1)
=[RegistrationNumber].Column(2)

The TextBoxes will then *display, but not store* these other two pieces of
information depending on the registration number currently displayed in the
CommboBox.
Click to expand...
 
Back
Top