vba

  • Thread starter Thread starter amit badgi
  • Start date Start date
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.
 
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
 

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

creating forms in access 1
How to write SQl query for Access forms 2
need help on access with sql 1
sql queries for access forms 1
Form/subform worries 2007 1
How to limit insertion of records 3
Manually storing Data to a field 8
access question 2

Back
Top