Where Condition (open form action)

[Andy12]

Yo,

Alright I will explain my situation, I work in a concrete company, and we do
a lot of service afterwards. So I have designed a database to track service.
In my database I have a form for each lot and in this form I have tab
control. In the one of the tabs I have another form viewed in a spreadsheet
to show multiple services for just that lot. What I want to do is be able to
DblClick on a feild in the spreadsheet form and open another form with that
specific record.

What I have done so far is created a macro with action open form. And on
the properties of one of the feilds in the spreadsheet form, I applied the
macro to the DblClick event. The macro works itself but, only opens the form
to the first record in that table. I want to open that form with that exact
record some sort of link. I think I have to use the Where condition in the
macro but every expression I used doesn't work. DOES ANYBODY HAVE ANY
SUGGESTIONS?? PLEASE!

Thanks

 

[Jeff Boyce]

Andy

You have "a form for each lot"...

What does that mean? We aren't there, and don't know your business the way
you do.

What does concrete and service and lots have to do with each other?

You're describing forms ... but in Access, everything starts with the data.
What is your underlying data structure?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Andy12]

Jeff Boyce,
Thank you for responding to my question. But as soon as I posted this
question I figured out how to do. Thanks anyways sorry about wasting your
time.

 

[Jeff Boyce]

Consider posting a more comprehensive description, and then the solution you
found. Perhaps someone else might someday run into the same issue you did
and would appreciate knowing how you handled it...

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Athens]

Thats exactly my problem, but now i dont know how she hndled it...
im still stuck in a rutt.

 

[whatthe1]

open form action

So close!

This is my exact situation and I still can't figure it out. Please, someone tell me how to make a field in a datasheet open a form to that record.

Many regards,
RD