Deleted un-necessary combo box on form .....

[Guest]

Hi All,
I have deleted an unnecessay combo box on my form and now when I open the
form I get a pop-up box with
Enter Parameter Value
tblMain.Distribution16

I click ok and it goes away and opens the form...How do I get it to stop
doing this? I just want the form to open.

I do not have this field in the Main Table any longer.

Any Advice?

 

[Guest]

Try finding where you still reference it by clicking on TOOLS - Analyze -
Documenter. Clock on forms and select that form. Click on options and select
Names and Properties, click ok, click ok. Click on the icon that is a blue W
to take the results to Word and find the offending object.

If it is not there the repeat the same process for the query that is the
source for the form.

 

[Dirk Goldgar]

In

Hi All,
I have deleted an unnecessay combo box on my form and now when I open
the form I get a pop-up box with
Enter Parameter Value
tblMain.Distribution16

I click ok and it goes away and opens the form...How do I get it to
stop doing this? I just want the form to open.

I do not have this field in the Main Table any longer.

Was the combo box you deleted named "Distribution16"? Check the form's
Order By and Filter properties (on the Data tab of the form's property
sheet in design view) to see if either of them contains a reference to
[Distribution16]. Also check the form's RecordSource property to see if
there's some reference to this field.

 

[Guest]

Thanks for the help....I have it all cleared up now

 

[Guest]

Thanks for the help. I have it all cleared up now.

In

Hi All,
I have deleted an unnecessay combo box on my form and now when I open
the form I get a pop-up box with
Enter Parameter Value
tblMain.Distribution16

I click ok and it goes away and opens the form...How do I get it to
stop doing this? I just want the form to open.

I do not have this field in the Main Table any longer.

Was the combo box you deleted named "Distribution16"? Check the form's
Order By and Filter properties (on the Data tab of the form's property
sheet in design view) to see if either of them contains a reference to
[Distribution16]. Also check the form's RecordSource property to see if
there's some reference to this field.

--
Dirk Goldgar, MS Access MVP
www.datagnostics.com

(please reply to the newsgroup)