Pls help-Queries thorugh form fields

[pooja.bhandari]

Hi ,

I need to make a Training Management System as directed by my Boss urgently

Well the problem i m facing is When i update the value in text boxes/Combobox of a form and click 'Display Results' Button to display the results of a query based on Text boxes/Combo-box values, it gives me nothing.
Query is perfectly correct, i checked it. I dont know why it is not picking the updated values of textboxes/combobox on the form.

I am not using any kind of programming/ code in this Project.
I am using only Accesss nothing else even not VBA, dont have licence of SQL Server etc.

 

[MStef]

Try this in query criteria:
[Forms]![YourFormName]![FieldName]

 

[pooja.bhandari]

I am doing the same MStef. I am writing query as below :

SELECT [Trainee-info].[Emp-Id], [Trainee-info].Fname, [Trainee-info].LName, [Trainee-info].Institute
FROM [Trainee-info]
WHERE ((([Trainee-info].[Batch-Id])=Forms![QBF-Form]!batch) And (([Trainee-info].[Th-No])=Forms![QBF-Form]!thno)) Or ((([Trainee-info].[Th-No])=Forms![QBF-Form]!thno) And ((Forms![QBF-Form]!batch) Is Null)) Or ((([Trainee-info].[Batch-Id])=Forms![QBF-Form]!batch) And ((Forms![QBF-Form]!thno) Is Null)) Or (((Forms![QBF-Form]!batch) Is Null) And ((Forms![QBF-Form]!thno) Is Null));

Pls check why it is prompting me to enter 'Form ! QBF-Form ! Batch' and ''Form ! QBF-Form ! Th-no' in the pop-up-box.

 

[MStef]

check the all names in form, if they write correct in qry.

 

[ColinEssex]

MStef - be aware that this question has been posted at least 3 times.

Col

 

[pooja.bhandari]

check the all names in form, if they write correct in qry.

Checked !!! everything is correct.
Can i send my database to on your email?
If you allow, pls give me ur email id.
I'll be highly obliged.i urgently need to do this.

 

[pooja.bhandari]

Checked !!! everything is correct.
Can i send my database to on your email?
If you allow, pls give me ur email id.
I'll be highly obliged.i urgently need to do this.

Hi
I have attached my database in my other post with same subject, pls go thorugh this and help me out
I'll be highly obliged.