Inputbox passing "answer" to field on subform

[Caitlin11]

Hello - I have searched this forum looking for an answer to my question and cannot find anything that works.

I have a form with a subform on it. The subform has a combo box that allows the user to select a "period" (PK, K, 1-4). This is saved in a field in my table called "period". When the form is opened - I have an input box asking them which "period" they would like to enter data for. I would like the answer to that question to be set as the default value (and displayed on the sceen) for my combo box for "period". Any ideas on how to get this to work? I don't need it to look up records for that "period" - just don't want them to have to set the "period" for each record they enter. This is a simple data entry form for teachers to enter student data.

Thanks in advance!

 

[WayneRyan]

Hi Caitlin,

I don't use input boxes (rather use a form), but can't you just:

Me.SomeFormControl = InputBox("SomePrompt", ...)

Wayne

 

[Caitlin11]

Hi - I tried that but I keep getting an error on the line:

me.period_combo = inputbux("Enter the period")

I had that line in the "on open" trigger in the FORM property.