Access 2007 - Please help with dependant info in forms

A_Barnes

New Member

Join Date: Jun 2011

Posts: 2

10th Aug 2011

I have a dilemma. The shop is particularly busy in the summer and I want to design a database that will make entering some of the information a lot easier. I have in my database a field for Supplier and a field for Brand. At least one of the suppliers only contains one brand it could possibly be and I was wondering if it was possible to automatically select a specific Brand if a specific Supplier was selected within the form.

If you can answer this one I will do this in your honour.

« Formating based on value between two numbers | Calculated field producing possible 4 different results »

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts BB code is On Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are Off Forum Rules

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert Excel 2007 data forms to Access 2007 ?	Cris22149	Microsoft Excel Misc	0	19th Nov 2008 02:13 AM
In Access 2007 why does info disappear?	smprice	Microsoft Access Getting Started	6	16th Apr 2008 08:53 AM
create a list dependant on info in a column	=?Utf-8?B?U3RldmU=?=	Microsoft Excel Worksheet Functions	3	18th Jun 2007 05:11 PM
Dependant Forms Structure	=?Utf-8?B?QmVybmFyZCBQaWV0dGU=?=	Microsoft Access Forms	5	19th Dec 2005 02:55 AM
Can users enter info into forms who don't have Access?	=?Utf-8?B?Y3N0ZXc3Mg==?=	Microsoft Access	2	20th Apr 2005 11:02 PM