[mso] Re: Access 2003 - forms

Content-Type: text/plain;
        charset="us-ascii"
Content-Transfer-Encoding: 7bit
Perhaps I can help here.

 

There are two ways of doing this, the Wizard way and the Full Works way

 

 First of all, create your form from the original table without any lookups
using the Form Wizard. At this point you should be able to add and edit
data.

Now, you have a choice.

 

The Wizard Way

==========

 

In Design view, select the field you wish to convert to a lookup field,
Select Properties, click on the Data Tab and write down the Control Source
Name.

Delete the control.

On the Form Design Toolbar, Ensure the Control Wizards button is selected.
Drag a Combo Box or a List box from the toolbar to the right place on your
form and the Combo Box Wizard will open.. This will lead you though the
steps required to select a field from another table. When you get to 'Store
the selected value in this field.' select the Control Source Name you
recorded earlier.

 

The Full Works Way

============

Go to Design View, select the control you wish to convert to a lookup field
and right click on it. From the Menu, select Change To and select Combo Box
or List Box. 

 

Right click on your new control and select Properties.

 

On the Data tab,  select Row Source and click on the button marked with
three dots at the end of the row.

 

This will open up a Query Builder form with a SHOW TABLE box in the
foreground allowing you to choose from where you want to get the data.

 

Select the table from where you want to get the data, and click ADD and then
click on CLOSE.

 

The table will now appear in the top section of the Query Builder.

 

 

Drag the field(s) you want to display from the selected table into the field
section of the query grid. 

 

When you have finished, close the Query Builder form.

 

You will then get a message "Do you want to save the changes made to the SQL
Statement and update the property?" 

 

Click on YES.

 

Save your form.

 

Your Combo or list box will now show the new data

 

 

 

Easy when you know how..

 

With best wishes

 

 

Nigel

 

 

A Star Software Ltd

8 Finchley Way N3 1AG

Tel: 020 8349 4714

Mob: 07976 655709

www.astarsoftware.co.uk

 


cid:image002.jpg@01C8579B.1865C7D0

Referrals are a large way we get business, word of mouth is important. A
Star Software are proud members of  <http://www.bni-barnet.co.uk> BNI a
group of business and professional people who having vetted each other's
standards, meet regularly to do business and pass business on.

So not only would we like you to introduce us to someone you know who would
appreciate working with us, but should you need anything from legal or
accountancy advice, plumbers to osteopaths, I would be happy to give you a
personal recommendation to help you. It's better than taking a risk with the
Yellow Pages.

 

 




*************************************************************
You are receiving this mail because you subscribed to mso@xxxxxxxxxxxxx or 
MicrosoftOffice@xxxxxxxxxxxxxxxx

To send mail to the group, simply address it to mso@xxxxxxxxxxxxx

To Unsubscribe from this group, visit the group's homepage and use the dropdown 
menu at the top.  This will allow you to unsubscribe your email address or 
change your email settings to digest or vacation (no mail).
http://www.freelists.org/webpage/mso

To be able to share files with the group, you must join our Yahoo sister group. 
 This group will not allow for posting of emails, but will allow you to join 
and share problem files, templates, etc.:  
http://tech.groups.yahoo.com/group/MicrosoftOffice . This group is for FILE 
SHARING ONLY.

If you are using Outlook and you see a lot of unnecessary code in your email 
messages, read these instructions that explain why and how to fix it:
http://personal-computer-tutor.com/abc3/v28/greg28.htm
*************************************************************

Other related posts: