Retreive record from subform by 'Click'

N

netadmin

I think I've seen how to do this somewhere on the site, but not quite sure if
I understand how to do it. I know a little on expressions and sql, but very
little. I tried it with the DoCmd, but it didn't seem to work. Mabey I'm
doing it wrong somehow.

Any easy suggestions would be appreciated!
 
W

Wayne-I-M

Hi

Can you be a little more specific about what you trying to do. I'm sure
someone will be able to offer help but you do need to say what the questions
is to get an answer.
 
N

netadmin

Hi Wayne,

Yes, I'm sure that would help.
What I've got is a form that has a Part Number field with a time stamp and a
a set of check boxes for either selecting 'Start or Finish'. I've also got
(2) subforms on this form (1) showing the jobs that have been started but
not finished, the other subform shows jobs that are also unfinished but
greater than 96 hours (these are the late jobs.
What I need is to be able to select one of the unfinished jobs in the first
subform and have this be the active record so the user can select finish for
this job. I don't need to be able to do this from the 'Late jobs' since this
will also be shown in the first subform. I think by specifuing a relationship
could possibly do this, but since it's a subform based off of a query, I
don't beleive I seen this avaialble in the relationship setting. Also, maybe
a double-click would be a better way to go? If a user would click it once, I
wouldn't want the record in the form to change that easy.

I hope that this is a little more understanding, or if more information is
needed, please let me know.

Thanks!
 
N

netadmin

A more clearer representation of the form would be;

tblPrtNum.tblPrt StartTime.tblPrt Yes/No



qrytbl.Incomplete.subform qryOldest.subform

In the qrytbl.Incomplete.subform I need to click the tlPrtNum.tblPrt and
make it the "current" record.

I see that there is a 'doubleclick' option in the properties so my previous
question on this is answered.

I tried the DoCmd a few different ways, but it didn't work. I'll keep trying
it unless there's another way?

Thanks,
 
Top