open a form based on another

[bml337 via AccessMonster.com]

I have two forms "client" and "employee details" I want to put a hyperlink
on the client form that will open up the employee details. the relationship
is as such. one to many client to employee details.

client; ID, employee ID

employee details; ID, client ID

i think im getting stuck on the where condition.

 

[Guest]

A hyperlink is not approriate here. All you need is to use the OpenForm
method.

 

[bml337 via AccessMonster.com]

OK but i still need to specify the where condition in the macro

A hyperlink is not approriate here. All you need is to use the OpenForm
method.

I have two forms "client" and "employee details" I want to put a hyperlink
on the client form that will open up the employee details. the relationship

[quoted text clipped - 5 lines]

i think im getting stuck on the where condition.

 

[Guest]

Don't use a macro. Just do it in VBA.
--
Dave Hargis, Microsoft Access MVP

OK but i still need to specify the where condition in the macro

A hyperlink is not approriate here. All you need is to use the OpenForm
method.

I have two forms "client" and "employee details" I want to put a hyperlink
on the client form that will open up the employee details. the relationship

[quoted text clipped - 5 lines]

i think im getting stuck on the where condition.

 

[bml337 via AccessMonster.com]

i dont know any vba

Don't use a macro. Just do it in VBA.

OK but i still need to specify the where condition in the macro

[quoted text clipped - 5 lines]

 

[Guest]

It would be something like
EmployeeID = Forms!ClientForm!Employee

Just use the name of the field in the other form's record source, and the
name of the control in the current form that has the value you want to use.

I suggest you learn VBA. It makes life a lot easier.
--
Dave Hargis, Microsoft Access MVP

i dont know any vba

Don't use a macro. Just do it in VBA.

OK but i still need to specify the where condition in the macro

[quoted text clipped - 5 lines]

i think im getting stuck on the where condition.

 

[bml337 via AccessMonster.com]

great thank you. any suggested books for reading... for a novice?

It would be something like
EmployeeID = Forms!ClientForm!Employee

Just use the name of the field in the other form's record source, and the
name of the control in the current form that has the value you want to use.

I suggest you learn VBA. It makes life a lot easier.

i dont know any vba

[quoted text clipped - 4 lines]

 

[Guest]

Haven't read this one yet, but it may be an option for you:
http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764556592.html
--
Dave Hargis, Microsoft Access MVP

great thank you. any suggested books for reading... for a novice?

It would be something like
EmployeeID = Forms!ClientForm!Employee

Just use the name of the field in the other form's record source, and the
name of the control in the current form that has the value you want to use.

I suggest you learn VBA. It makes life a lot easier.

i dont know any vba

[quoted text clipped - 4 lines]

i think im getting stuck on the where condition.

 

[Jan Bundsen]

I have Access 2002. Would this book work for me?

Jan

 

[Guest]

Yes, there is very little difference between 2002 and 2003.