ajaymansata
Registered User.
- Local time
- Today, 22:26
- Joined
- Dec 17, 2001
- Messages
- 25
Hi
I appreciate the help but as i have never done VB before i am facing a problem.
Well let me tell u exactly what i have with the right names and everything
I have a form named search form with three text fields and one search button
names of text fields are
lastname,SSN,studid,
Name of search button is search
As soon as the search button is clicked in the on click event of the button i fire a macro called search form.
Now in this macro in the condition i check whether onlu lastname,or only studid,or only ssn number or all three were entered.
say Only lastname was entered then in the action event i open a form named "when lname specifed".Now this form is a result of the query used to retrieve records corresponding to the lastname entered by the user.
Now what i want is that if the query retrieves no reocrds i should get a mssg box saying "No records present" instead of what i get now that is a form with no entry in it.
could anyone please tell me exactly where and what have i to do.
Ajay
I appreciate the help but as i have never done VB before i am facing a problem.
Well let me tell u exactly what i have with the right names and everything
I have a form named search form with three text fields and one search button
names of text fields are
lastname,SSN,studid,
Name of search button is search
As soon as the search button is clicked in the on click event of the button i fire a macro called search form.
Now in this macro in the condition i check whether onlu lastname,or only studid,or only ssn number or all three were entered.
say Only lastname was entered then in the action event i open a form named "when lname specifed".Now this form is a result of the query used to retrieve records corresponding to the lastname entered by the user.
Now what i want is that if the query retrieves no reocrds i should get a mssg box saying "No records present" instead of what i get now that is a form with no entry in it.
could anyone please tell me exactly where and what have i to do.
Ajay
