Geek Answers Handbook

Data entry with combo box in Datasheet View in MS Access

I need help creating my first application in MS Access 2007.

Consider a table in MS Access with an AgeGroup column, and the possible values ​​for this column are Child and Adult. Is there an option in MS Access for entering data into this column using a combined field with these two values ​​in the Datasheet view ?

+5
source share
2 answers

A simple (but dubious) solution:

(in strict accordance with the OP question)

  • Create a new table
  • Add the column that you want to control with combobox and give it the column name and type Text.
  • , , Lookup MS Access
  • Display Control TextBox Combo Box
  • Row Source Type= Value List
  • Row Source : Child,Adult

, , , MS Access , Child Adult AgeCategory. , . .

: HansUp, , .

, , :

  • , .
  • combo-box
  • Datasheet View. Datasheet View , , .
+5

, , , ( ) .

. . . " " .

+2

More articles:


All Articles