filling unbound fields according to combobox value

[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

 

[Rick Brandt]

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.

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.

 

[Rani]

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 ?

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.

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.

 

[Rani]

thanks I found my error

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.

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.