simple data-entry combo box in fields

[Guest]

I have a table with several fields, and a data-entry form in form view based
on that table.

I'd like to create a combo box in a field so the user can simply select a
value to fill the record (e.g. Gender field: Male/Female). I know how to do
this in the table, but don't know how in the data-entry form.

Thanks for any help

 

[Graham R Seach]

Sam,

Because there can only ever be two values, Male/Female combos are pretty
straightforward:

RowSourceType = Value List
RowSource = "Male";"Female"
DefaultValue = "Male" 'or "Female" if you prefer
ControlSource = 'as required by your application

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

Microsoft Access 2003 VBA Programmer's Reference
http://www.wiley.com/WileyCDA/WileyTitle/productCd-0764559036.html

 

[Guest]

Thanks Graham, but I don't see "RowSourceType" or "RowSource" when I go to
Text Box property of that field in form??

Regards,
Sam

 

[John Vinson]

Thanks Graham, but I don't see "RowSourceType" or "RowSource" when I go to
Text Box property of that field in form??

A Combo Box is one type of control; a Text Box is a different type of
control. A text box doesn't have these properties, but a combo does.

Either delete the textbox and use the Combo Box tool on the Toolbox to
add a combo; or right mouseclick the textbox and select Change To...
Combo Box.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps