Filter Subform

K

K

Hi all, I have table in subform control which i have put on a Form
call "Main Form". Table name is "Data" and Subform name is "Data
Subform". On the Form "Main Form" just above from subform control i
have also put unbound Textbox control which i call "txtSrch". I just
want some kind of code or way that when ever i put a ID number in
Textbox control which also appear in first coloumn of the Table which
is in Subform then Subform should get filterd on that ID Number. I
also want that if i put some kind of ID Number which dont appear to be
in the Table of Subform then i should get message box say that "This
ID dont exist". Please can any friend can help me on this.
 

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

DLookup in Continuous form 0
Populate main form from subform record 0
VBA code returns no records hwenKey ID is added 14
main form/subform 1
Sharepoint not capturing staff name when automation runs 0
Locked Subform still lets me delete a record 2
Referring to control in the active subform 0
I can't get this code to work 1

Top