Problems with setting values on a Form

  • Thread starter Thread starter David C. Holley
  • Start date Start date
D

David C. Holley

I have a form that contains code that sets values for various controls
on the form. I seem to be getting the 'You can't assign a value to this
control.' error message. I suspect highly that theres something going on
with the form since it appears to be only with specific controls.
What should I look for in the Form properties?
 
David,

Is the Control on your Form a combo box? If so check the control source.
Also check the positioning of your column(s) 0 being the first column 1 the
second etc.

HTH
 
David,

Is the Field you are getting the error on associated with a Combo box?
Check the control source of the Combo Or check your Column positioning. 0
being the first Column.

HTH

John
 
You cannot assign values to Calculated Controls or Controls that are bound
to Calculated values from the Form's RecordSource.
 
No its not. Just a text box. One of the problem children involved is set
via an code in an free standing module, would that make a difference
even though the control is properly referenced -
[Forms]![frmReservations]![txtOutlookEntryId] =
 
No its not. Just a text box. One of the problem children involved is set
via an code in an free standing module, would that make a difference
even though the control is properly referenced

[Forms]![frmReservations]![txtOutlookEntryId] = newAppt.EntryID

The appears to work fine when the form is opened directly from the
database window, however seems to get wacky when its open from another
form...

DoCmd.OpenForm "frmReservations", acNormal, , "[lngTransportId] =
[Forms]![frmInvoicing].form![subfrmTransportsInvoiced]![lngTransportId]"
 
Back
Top