How can I select one field in Microsoft Access and it auto-fills in another?

Question

I have a drop down box with the size of items, based on the size that the person clicks on the box, I want it to automatically fill out the price text field I also have on the form. Is this possible?

Also, is there a way to turn an access database into a program? I have a 'security' system in place, but I don't want people being able to open certain tables by just clicking them on the left!

Thanks

Answer 1

Create a query with the ItemSize and Price as selected fields.

Use this query as the Row Source property of your combo box (let's call it cboSelectItem).

Change the following properties of the combo box

Column Count:   2

Column Widths: 2cm;0cm        (or whatever units you use)

Now, in the properties for the combo box where you want to display the price, change the Control Source property to

=[cboSelectItem].Column(1)

======================================...

Once your DB is complete, you can specify Startup options, (Tools, Startup...), such as suppressing the database window, indicating which form to open, etc.