Quandry?!!

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

Guest

Hello

Access Projects

I don't know how I did this, but some of my controls on the form will show #name? and others will be blank. I know that the recordsource has not been set that is why I get the #name? message in the control, but this doen't happen for all of the controls.

I wrote a Stored Procedure with several parameters as a the eventual recordsource. The recordsource for the form has not been hard coded, but is set via VB. The problem is that some of the combo boxes will show #name? which means the data has not completed its return to the client while other combo boxes remain blank. I would like to have the boxes blank for all the controls. I know in Visual Basic 6.0 forms, you can set the text property of the control, but setting the property for this in code gets you an error message stating that that control is in read only

Does anyone know how to get around this?!

Thank you

Brandon Campbell
 
Just as you're doing with the form's RecordSource
property, you could leave the RowSource properties of your
combo boxes blank and set them via code after you've set
your RecordSource property.
-----Original Message-----
Hello,

Access Projects.

I don't know how I did this, but some of my controls on
Click to expand...
the form will show #name? and others will be blank. I know
that the recordsource has not been set that is why I get
the #name? message in the control, but this doen't happen
for all of the controls.
I wrote a Stored Procedure with several parameters as a
Click to expand...
the eventual recordsource. The recordsource for the form
has not been hard coded, but is set via VB. The problem is
that some of the combo boxes will show #name? which means
the data has not completed its return to the client while
other combo boxes remain blank. I would like to have the
boxes blank for all the controls. I know in Visual Basic
6.0 forms, you can set the text property of the control,
but setting the property for this in code gets you an
error message stating that that control is in read only.
 
Back
Top