vba

A

amit badgi

Hi all, i am new to the group. I am working on MS Acess, created a form
using access which has 4 options of business license number, business id,
name, phone number. Now I have around 10 access tables which I have to use.
I created the form and then wrote a query and attached it to a new macro
which inturn I attached it to teh search button as an onclick event. Now
when I run the form, after I enter a business id and click search, a new pop
up comes up and asks for business id again and once i enter it, it works
fine. Problem is that its not able to take teh input that I give in the
form. If anyone could help me out, it would great. Thanx.
 
R

rowiga

Welcome to the group....

Apparently Access can't find where you refer to BusinessID in your query. If
it's a control on a form make sure that your reference is proper and that the
form is currently open.

Forms!YourFormName!YourControlName
 
Top