SQL Where Condition

  • Thread starter Thread starter Greg Ripper
  • Start date Start date
G

Greg Ripper

I have 1 form in continuous forms view that I would like to have a user click
on and have it open another form to the record of the user just clicked.

I created an openform macro with the following SQL Where Condidtion

[studentid]=[Forms]![frmcounselorselect]![studentid]

studentid is the primary key for all the records.
the form to open is frmCounselorSelect
the primary key for the record is also studentid

The macro opens the form, but does not bring up any record. Anyone know
how I can get that record to open?

Rip
 
It needs to read something like this ...

"[studentid]=" & [Forms]![frmcounselorselect]![studentid]

So that when evaluated it outputs this ...
[studentid]=21
 
Back
Top