Object Required?

[HandJT]

Hi everyone!!

Can anybody tell me what I am doing wrong? I have this statement in my code and I keep getting "run-time error 424, Object Required" Any help would be greatly appreciated!! Thanks!

Forms_SearchResults[cboNDW].RowSource = "qrySearch

 

[RoyVidar]

If the form name is SearchResults, then I'd try:

[tt]forms!searchresults!cboNDW.rowsource ' or
forms("searchresults")("cboNDW").rowsource[/tt]

If the name is prefixed by "Form_" (as is usually seen in the properties window in VBE), then

[tt]forms!form_searchresults!cboNDW.rowsource ' or
forms("form_searchresults")("cboNDW").rowsource[/tt]

Roy-Vidar

 

[HandJT]

I tried those and it gave me "run-time error 438 Object doesn't support this property or method." I don't know what's up with it. What I have is a form that a user can perform a search, then another form that displays the information. On the results form I have a combo box that if there are more than one record on it with the particular DWG number on it, I want the combo box to display the NDW numbers and whichever one the user clicks on, it will display the information. Step one is to just get it to list them. I thought that I had it, but it would only list the records when I search by DWG# 345, but if I searched by DWG# 678, it would only list one even though I know there are more. So, I'm not sure where to go from here. Any other suggestions?

 

[RoyVidar]

Don't understand a thing - to much contradicting information. Limit it to one form one combo.

Post the name of the combo, name of the form, if this is performed within the same form, the whole code assigning whatever rowsource to this combo (current rowsource, wanted rowsource). Sample data (contents of the lookuptable, datatypes.

The 424 occurs most often when one is trying to address a control without qualifying it with the Forms keyword and form name.

438 occurs when trying to reference a property or method of a control that the control doesn't support/have - rowsource for a text control

Roy-Vidar

 

[HandJT]

Sorry if this sounds confusing. I'll break it down.

Form 1 -- Search form with four ways to search the database, DWG, RMA, NCT, JOB. All are numbers.

Form2 -- Results form that displays the results. This includes a combo box for which I would like it to list the records according to the record id number which is an autonumber so it's unique to each record named NDW.

My problem -- Step One -- Need the combo box to list all the NDW records that has the certain DWG, RMA, NCT, JOB number on it that the user is searching by.

Step Two -- Would like it to display the information on the record when I user chooses one of the NDW numbers from the combo box.

Does this make any sense?

 

[RoyVidar]

Nope - see the above list - or have a look at the faq section of this forum. A whole section deals with combos (or is "form 1" or "form2" the names of the form, just substitute above suggestion).

Roy-Vidar