listing only records where some fields are null 1

[tacexpo]

i have a form which consists of few text boxes + combo boxes.

form shows all the transactions that has been made.
(all fields are bound).

for ex. when user opens the form, they see 100 records they can scroll through. here's the tricky part. I only want to show records where cboOSID and cboAcct is null.
that is because at first, those two fields are blank(other fields are not blank). user selects from combobox and update query will run to update those two fields in to the table.

i would like to prevent from overwriting values so i was hoping to find a way to only show records where those two combo boxes are null.

i've tried creating a select query on form_load but it's not working..

any ideas?

ps. am i making sense? pretty much i would like the form to only populate where cboOSID and cboAcct is null

 

[PHV]

Bind the form to a query instead of the table.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tacexpo]

exactly what i needed. thank you.

 

[tacexpo]

another question. If i want the form to update after user types in txtPRnum, how would i do that?

 

[PHV]

Sorry, I don't understand the question.
If the form is bound then the update is automatic.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[tacexpo]

so instead of showing all 100 records, open in a addMode where user can type in a number to find a specific record.

i can't do that with the way things are set up now huh?

 

[tacexpo]

i changed it using dLookup but it's taking to long...

i guess my final question is.. is there a way to jump to a certain record?
like if 100 records show up but i wanna jump to 54?

since record selector is filtering out some records
the record number doesnt match the number on the form