query problem

[accessnewbie]

Hello all,

I am new to access but not to DB development. I have a lot of experience using php/mysql but not with access and I am creating an application that I need some assistance with. Here is my problem:

I have two tables:

1. client
2. employee

I have one multi-tabbed form containing the follwing tabs:

Page one
Page two
and so on...

Page one lists client names and sorts them by the number of employees each client employees. The quesry is presented in a lsit menu that activates a macro upon selection by the user. The macro goes to page two.

Page two should take the chosen client name from page one (it comes from combo0) and use it to display all employees for the chosen client.

Here is my problem(s):

1. I get the follwing error when I run the query on page 2:

#Name?

2. I need two create a query that simply displays the name of the employees on page 2 via the selected client from page 1. The client and the employee tables are relational using 'client name' and the common field. The info will be coming from 'combo0' element in page 1 and run through a query one page 2.

Any ideas are greatly appreciated

Thanks in advance

 

[pcEars]

A tabbed form? do you mean a tab control on a form?

You might try a different approach...perhaps a form/subform with client data on the main form and their employee data on the subform. Then you'd eliminate the macro.

Or is the form more involved than that?

BTW-welcome on board!

 

[accessnewbie]

Yes a tab controlis what I have. This works best becuase I have multiple pages of data that need to be manipulated by the users selections. Each tab can serve as a different query display.

What about the '#Name?' being displayed as a result of my query? Can you give my\e any information on why this would be happening?

Thanks again

 

[pcEars]

2nd- search access help for "troubleshooting controls" to learn why you might be getting that message.

1st- I'm not sure exactly how you're trying to use the form to manipulate data. Perhaps you can post your form, query and some sample data to give a better idea.