Make Table Query field based on Form control

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

Guest

I have a Make Table Query that I would like to have create a field not from
any other table but custom. This field is called WeekNo and it is to be
populated from the value of a textbox control on a form.

I have tried this:
WeekNo:([Forms]![frmMyForm]![txtMyTextbox])
in the query's Design View in the field name area, but it just ignores this
field all together when creating the table. I have coded the form so it is
still open but just not visible when the query runs so there *is* a value for
the txtMyTextbox control available.

I can create the custom field by simply typing
WeekNo:("")
in the query design area, then the filed gets created but not populated!

I would like to be able to be able to have this custom field populate so
teachers don't have to be typing in the week number for each of hundreds of
students in some cases.

Any suggestions would be great!

Thanks in advance,
 
Your syntax should work as long as the form is open and the control has been
updated. Your control value might not have been updated if the focus is
still in the txtMyTextBox control.
 
Back
Top