Combo Box

[myxmaster]

Hi,
I have a combo box with 3 items, cash, credit, check. I would like to
select one of the items from the combo box and have the information
relevant to the selection populate a form . I am thinking that I need
to create a query and somehow tie the combo box to it but franlkly I
have been looking at this for weeks and cannot figure it out.
TIA

 

[Guest]

Hi

Not sure what your table look like so this is only a "maybe".

You should have in the table a Primary Field (autonumber or something like
this).

TblPaymentType
TypeID = AutoNumber
Type = Text

Type would be cash, credit, cheque, etc

If you inset the TypeID into another table as a foriegn keyfield that you
can build a relationship and this will allow you to select the "type" from a
combo and autopopulate the rest of your form.

Ensure you include the ID field in the combo

Open the form in design view and right click the combo and open the
properties box.
In the Data column select the RowSource and click the build option (...).
Use the wizard to create the query for the combo for you.

Hope this helps