Conditional skipping fields

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

Guest

I'm trying to code a data entry form where the user selects an option from a
drop down list and depending on the value the cursor moves to the area
pertaining to this.
e.g. Choosing from animal, vegetable or mineral.
If mineral is selected then the cursor bypasses the animal or vegetable data
entry options and goes to the mineral choices area and proceeds.
I hope this explanation is adequate.
Sub forms in this instance may be a little messy for the operator.
thanks
 
Sounds suspicously like a Spreadsheet converted to Access
You Should split into (at least) three tables animal, vegetable & mineral.
You can then have a subform for each "class") & make them visible according
to what the user selects.
Simpler (Better?) is to have a switchboard form with buttons to open these
forms

HtH

Pieter
 
The part about "goes to the mineral choices area and proceeds" is a bit vague!
Do you mean that you want to go to an area of the current form where data is
entered about minerals, or are you talking about going to another data entry
form? To move to a specific textbox on the form depending on the combobox
selection, you'd do something like this, where the Combobox is named
SubjectComboBox:

Private Sub SubjectComboBox_AfterUpdate()
If SubjectComboBox = "Animal" Then AnimalTextBox.SetFocus
If SubjectComboBox = "Vegetable" Then VegetableTextBox.SetFocus
If SubjectComboBox = "Mineral" Then MineralTextBox.SetFocus
End Sub

IF you mean something else, you can still use the same basic code, just
modify what goes after the "Then" portion of each line!

Good Luck!

Linq

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

Message posted via AccessMonster.com
 
Back
Top