M
Malekius
(Win Xp Pro Sp3 with MS Office 2003 PE)
I have been learning Access for one week, so I am a beginner, but I'll try
my best to relate my problem. I hope you can help.
First of all I have learnt about Tables. I have created a table ("tblItems")
which has 3 fields. The fields are NumberID, ItemClass and ItemName
respectively.
(Note for ItemClass field: There are 7 different classes and I'd to select
them quickly with a combo box when I use the Query.)
After I have created the Table, I begin to learn about Queries. My first
criteria to ask was [Which class of items are you looking for?]. Query promt
me for a text input and with correct input it returned a list of items of
that class.
It was fine but useless in my opinion. Because I know there are seven
classes and I know their names, but other users don't have to know them all
by heart. So I deciced to use a combo box instead of a simple text input box.
But how? Well I've made a major search in here and I've found this link and
followed its steps.
http://www.fontstuff.com/access/acctut08.htm
Forms can bear combo box. So form (or the combo box of the form) must be
linked to criteria of the selected field (in order to promt user for select
one a class)
I've done everything right but there is problem and I can't solve it.
If you write [Which Class?] in the criteria of the field named "ItemClass",
Query will ask you the question Which Class? and promt for a text input in a
dialog box.
But when I wrote [Forms]![frmPromt]![cboTry] in same criteria Query doesn't
start the form but instead it runs the same dialog box above.
It only says Forms!frmPromt!cboTry and waits for a text input. I think It
was supposed to run the form. (dialog box caption says Enter parameter value)
I even tried to fix it manually in SQL view mode but it didn't work...
Can you please help me?
I have been learning Access for one week, so I am a beginner, but I'll try
my best to relate my problem. I hope you can help.
First of all I have learnt about Tables. I have created a table ("tblItems")
which has 3 fields. The fields are NumberID, ItemClass and ItemName
respectively.
(Note for ItemClass field: There are 7 different classes and I'd to select
them quickly with a combo box when I use the Query.)
After I have created the Table, I begin to learn about Queries. My first
criteria to ask was [Which class of items are you looking for?]. Query promt
me for a text input and with correct input it returned a list of items of
that class.
It was fine but useless in my opinion. Because I know there are seven
classes and I know their names, but other users don't have to know them all
by heart. So I deciced to use a combo box instead of a simple text input box.
But how? Well I've made a major search in here and I've found this link and
followed its steps.
http://www.fontstuff.com/access/acctut08.htm
Forms can bear combo box. So form (or the combo box of the form) must be
linked to criteria of the selected field (in order to promt user for select
one a class)
I've done everything right but there is problem and I can't solve it.
If you write [Which Class?] in the criteria of the field named "ItemClass",
Query will ask you the question Which Class? and promt for a text input in a
dialog box.
But when I wrote [Forms]![frmPromt]![cboTry] in same criteria Query doesn't
start the form but instead it runs the same dialog box above.
It only says Forms!frmPromt!cboTry and waits for a text input. I think It
was supposed to run the form. (dialog box caption says Enter parameter value)
I even tried to fix it manually in SQL view mode but it didn't work...
Can you please help me?