Command button to open a specific record

D

DavisGail

I am using Access 2003. I have a form that has unbound fields to lookup
multiple criteria in a query and opens another continuous form that lists all
tasks by whatever criteria was chosen (assigned by, assigned to, etc).
On this continuous form, I would like to only have task name, status and
estimated completion date. Is there a way that I can then add a command
button to open yet another form for the complete details of the task?
 
D

Douglas J. Steele

Docmd.OpenForm "FrmTaskDetail", , ,"TaskID = " & Me!TaskID

or

Docmd.OpenForm "FrmTaskDetail", WhereCondition := "TaskID = " & Me!TaskID

This assumes that TaskID is a numeric field.

(At least you didn't charge them for the incomplete answer...)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top