Help with dataentry errors

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

Guest

Form is called New-Edit
I have an option group with three options
Out - Option11 with the value of 1
In - Option13 with the value of 2
Consult - Opiton15with the value of 3

If the Out is input,
then I want a field (combo box) hospital name to default to Memorial

If the In is input,
then I want a field (combo box) Receiving to default to Memorial

How is this best accomplished?
 
Private Sub Frame0_AfterUpdate()
If Me.Frame0.Value = 1 Then
Me.cboHospital = "Memorial"
End If


End Sub
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problems with my Select Case 3
Subform DataEntry Issue 2
Toggle DataEntry Programatically 3
second Option group not recognized 1
if and then in a form 4
data entry in subform.if empty no place for dataentry 2
Undo a combo box selection 3
Excel Concatenate Form Name to Parse for function 1

Back
Top