Please help!!!!

[George]

Hi there. I have an update table and 3 different forms, which i use
individually to update certain fields in the same table. The forms represent
terminated employees, new employees and promoted employees.

I need to view the information previously captured in this one table.
However need to view the info, using the specific form applicable i.e. if i
only want to view the terminated employees then the terminated employees form
must be called with only the fields relevant to that form and it should be in
datasheet view.

I have used a parameter query with a list representing the different types
i.e. terminations, engagements and transfers, however when selecting the type
, the same form is opened for every type.

Any assistance would be much appreciated.
my email address is (e-mail address removed)

 

[KARL DEWEY]

I have an update table and 3 different forms
What do you mean by 'update table?'
Post the SQL for your query.

 

[George]

Hi Karl,

Thank you for the reply. My apologies for being confusing. Update table
means that the table data is updated through use of the different forms i.e.
new engagement, terminations and transfers. There is a action type field in
the table and is used in each form to indicate the action type i.e. -
employee engagement/ termination or transfer (this should allow me to use a
parameter query on this field). Hope this makes sence.

 

[KARL DEWEY]

I repeat --- Post the SQL for your query.