how do i use formulas in access?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

i am creating a dtabase for my study and am having a slight problem.
I need to have a field on a form that references to an input number and
appears when the end user tabs to the next form
eg user enters the following: item = 0234; no req = 5
then field description would then automatically show what the item number
0234 is.
I then need to link it to another end report
 
Michelle

You need a table that lists all the items with the item number and the
Description.

A couple of approaches you can take...
1. Make a query which includes both the eisting table and the items
table, joined on the item number from both. You can then include the
Description field in the query, and hence represent it directly on the
form. Therefore when the item number is entered the description will
utomatically be shown.
2. Use an unbound textbox on the form for the description, and use a
DLookup() function in its Control Source to reference the Description
from the items table.
 
Back
Top