Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Forms / March 2008

Tip: Looking for answers? Try searching our database.

some type of lookup

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
SheriTingle - 16 Mar 2008 07:06 GMT
Hi and thanks for the help. I am using Access 2007. I have a form with a
"Vendor" field and a "TaxCategory" field. When I type in a vendor the
taxcategory is always the same. Examples:  Vendor=Staples, TaxCat=Supplies;
Vendor=Applebees, TaxCat=Client Dining; Vendor=American Airlines, TaxCat=Air
Expense...

How can I set this up so I no longer type in the TaxCategory and it is
automatically populated for me when I type in the vendor name?

: )
DM - 16 Mar 2008 09:53 GMT
I would add that to a vendor table. then if you want to see it on the form
instead of only queries and reports, add an unbound combo box for vendor
selection and set it to see the table and show that field.

if you don't know how to do this after dropping an unbound box, click on
format, change to and select combo box

double click on the box to go into the properties, set the control source to
vendor

select the row source and select the vendor table then click on the ... to
the right of this in the properties. if your Access is fully loaded, it will
go to a SQL Statement (query design view if you will). if it don't ask to
build based on the table, you will have to select the tables and establish
relationships.

then drop (vendor) and (tax status) from the vendor list into the query and
save/close.

copy that box and paste another one next to the vendor selection box. go
into the properties, row source ... and re-arrange (vendor) and (tax status)
to (tax status)and (vendor) and save/close

save your form and click view and test.

I would also set the tax status field so no one can select from it.

> Hi and thanks for the help. I am using Access 2007. I have a form with a
> "Vendor" field and a "TaxCategory" field. When I type in a vendor the
[quoted text clipped - 8 lines]
>
> : )
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.