List box

[Guest]

How can i update the form to have a pull down menu for field and have it
update/input to the master table:
TYPE SEPARATION (Officer, Medical,Retiree,Regular)
TYPE CASUAL PAYMENT (EFT, SRD)
TYPE INITIAL PAYMENT (EFT, SRD)

 

[John Vinson]

How can i update the form to have a pull down menu for field and have it
update/input to the master table:
TYPE SEPARATION (Officer, Medical,Retiree,Regular)
TYPE CASUAL PAYMENT (EFT, SRD)
TYPE INITIAL PAYMENT (EFT, SRD)

You'll have to explain your question in a bit more detail. It sounds
like you simply want to create a Form based on your table, and use the
combo box wizard from the Toolbox to create three Combo Box controls
on that form, bound to these three fields. Is that what you mean by
"update the form"? What does the form have on it now? Does it help to
right mouseclick an existing Textbox control and choose the option to
change it to a Combo Box?

John W. Vinson[MVP]

 

[Guest]

Well i have the form now and all entryies are posted by individuals so the
problem i have is they all put different info in the form box. i just what
to make it eairser and just choose a selection. i made another table and got
the box to work correctly except it would not post to the main table where
the info is stored. hope that helps out

 

[Guest]

yes i can right click and choose combo box.

You'll have to explain your question in a bit more detail. It sounds
like you simply want to create a Form based on your table, and use the
combo box wizard from the Toolbox to create three Combo Box controls
on that form, bound to these three fields. Is that what you mean by
"update the form"? What does the form have on it now? Does it help to
right mouseclick an existing Textbox control and choose the option to
change it to a Combo Box?

John W. Vinson[MVP]

 

[Guest]

I figured it out thank you for your help