Hi,

I have a MS Access form that is populated from a query executing from the results of another form. What I wish to do is if there are no records returned in the query then the form should not show and I would like to show an error message instead.

What I am thinking is to have a check in the Form load procedure to determine this, but I do not know how to check how many records there are in the query ... can any one...

Hi i'm trying to create a code that searches for a word i type in, in a table. kind of like a parameter query but in a visual basic code.

if i have the following entries in a column called 'ProductName':
-Poster Paint
-Poster Paper Rolls
-Pink Paper

and i type in the word 'poster' in a textbox, click a command button to search the fields then entries 1 and 2 should be displayed.

what...