Forcing a result

  • Thread starter Thread starter Steve Tarr
  • Start date Start date
S

Steve Tarr

I have a table (Call it table A) with columns A, B, and C.
Column A contains a code (for example A23.5)whilst columns
B and C contain description and complexity respectively. I
am trying to create a new form that when a user types a
code (which is contained within table A) into a field
called Code, A result is produced in another field
containing the complexity

Example of table A
Code Description Complexity
A23.5 Total Knee replacement Major Complex
A23.6 Hip Replacement Major
B13.4 OGD Minor
B16.9 BXS Intermediate

Example of New form
field one field 2
user types code A23.5 Major complex is
produced

There are only 4 complexities to choose from

New user to Access anyone help??

Thanks
 
Field1 on your form needs to be a combobox based on a query based on TableA. The
fields in the query need to be Code and Complexity. Sort ascending on Code. The
combobox needs to have the following properties:
Bound Column: 1
Column Count: 2
Column Widths: 1;0

Put the following code in the AfterUpdate event of the combobox:
Me!NameOfTextBox = Me!NameOfCombobox.Column(1)
 
Back
Top