Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

updating access query


  • Please log in to reply

#1
djames

djames

    New Member

  • Member
  • Pip
  • 3 posts
have a form with 2 combo boxes, the first is company name, the second is contact name. When the company name is entered a query limits the contact names to that company This works fine until the operator goes back and changes the company name or goes on to a new record the contact field never updates and the original list never changes. I'm not sure if I need VBA code or if there is another solution. Any input is appreciated.
  • 0

Advertisements


#2
nanook

nanook

    Member

  • Member
  • PipPip
  • 13 posts
Is there a reason that the contact name is also a combo box? Could you change the contact to just a text box whose control source is coming from the first combo box (company name)? Just a thought...
  • 0

#3
djames

djames

    New Member

  • Topic Starter
  • Member
  • Pip
  • 3 posts
Thank you for your input, let me further explain the application and then it may make sense or you may have a better idea.
There are 3 tables involved (I tried to limit the repeative entry required).
1. company table which contains corporation names (ie General Motors, Ford Motor Company, ...) and addresses
2. plant table which contains plant name (ie city xxx assembly plant, city yyy plastics plant, ...) and address, [each plant is tied to a corporation]
3. contact table which contains name, phone, mobile, fax, email [each contact is tied to either a corporation or a plant].
The request for quote form has a 4 combo boxes "Corporation", "Plant", "Attention to" and "Requested by".
What I tried to do is limit the choices in the "Attention to" combo box based on the Corporation selected, and the "Requested by" combo box based on the plant selected. I used a query and it works the first time but if you change the corporation or the plant selection the contact list still show as the original list, the query does run or update. This is also true if you complete the form and enter a new request for quote without closing the form. The only time it works is if you close the form.
Ultimately this with other information will be dumped to a boiler plate quote letter which is a word document. Hope you can understand the intent, I have worked with Visual Basic 6 and now just starting with Access 2000 any help will be appreciated.
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP