SQL Where Condition

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
 
D

Danny J. Lesandrini

It needs to read something like this ...

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

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

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

Similar Threads

Where Statement 1
subform for inputting grades not working 0
cbo in subform 1
finding a record in continuous forms 4
get value from form field 4
Can't pull all the 2
Can I save a sql statement generated by a search form? 1
MS365 WORD: How to Create Macro Button to CLEAR ALL fields in fill-in form 1

Top