lost data in one fied after performing a search

[RLehrbass]

I have a form frmMember, it has a search button that performs a complex search of fields. after performing my search my [BaseDues] field shows #Name? BaseDues is set by a CBO in the field above.
It works correctly except after the search...

Here is the Code for the Search Button:

Private Sub cmdSearchForm_Click()
On Error GoTo Err_cmdSearchForm_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = "frmSearch"
DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdSearchForm_Click:


Exit Sub

Err_cmdSearchForm_Click:
MsgBox Err.Description
Resume Exit_cmdSearchForm_Click

End Sub

frmSearch Row Source is:

"CompanyName";"PhysicalAddress";"MailingAddress";" ContactFirstName";"ContactLastName";"ContactPhone" ;"BusinessPhone";"Fax";"Email";"WebSite";"Business Type";"KeyWords"

[Micron]

lots of confusing comments here. Your search button code does nothing other than open a form called frmSearch and passes an empty variable as a WHERE condition. There is no search performed by the button click. Also, forms don't have row sources - they have record sources. Anyway, the error usually means a reference you are using cannot be resolved. Try stepping though the code that exectues after the button click to see if you can detect which line generates the error. Or is the error showing up in a form control?

[RLehrbass]

it is not actually giving an error. The data in the BaseDues is no being displayed as it does in the standard form view and scrolling through the records with the navigation at the bottom. instead of giving the value from [tblMemberType].[BaseDues] in currency (ei: $100.00) in the form view, it displays #Name?. while viewing the form selected by the search.
Also the [frmSearch].[cboSearchField] is what the above mentioned "Row Source" is from. it designates what criteria I can select my search from...
I am thinking I do not have something set to source the BaseDues from, but I just don't know where to look...

[RLehrbass]

Question:

I believe it is in these lines of code not having the [tblMemberType] included in the Record source???

Form_frmMember.RecordSource = "select * from tblMember where " & GCriteria
Form_frmMember.Caption = "Members (" & cboSearchField.Value & " contains '*" & txtSearchString & "*')"

How do I add the tblMemberType to the TblMember?
Would I simply add code to the end of the first line:

Form_frmMember.RecordSource = "select * from tblMember where " & GCriteria And "Select * from tblMemberType where " & GCriteria?

[June7]

How are tblMemberType and tblMember related? What are the PK/FK fields? Build query that joins these tables.

SELECT tblMemberType.*, tblMember.* FROM tblMemberType RIGHT JOIN tblMember ON tblMemberType.ID=tblMember.TypeID;

[RLehrbass]

tblMember PK = ID;
tblMemberType PK = ID;
[tblMemberType].[ID] related to [tblMember].[MemberTypeID] join type 1 (both table are equal.)

Current code:
Form_frmMember.RecordSource = "select * from tblMember where " & GCriteria

Your code suggestion:
SELECT tblMemberType.*, tblMember.* FROM tblMemberType RIGHT JOIN tblMember ON tblMemberType.ID=tblMember.TypeID;

How do I add this part of the code at the end???:
where " & GCriteria

[Micron]

You've posted info that suggests [BaseDues] is a form control that contains an expression that can't be resolved. If it contains an expression, post it and maybe explain a bit about it.

[June7]

SELECT tblMemberType.*, tblMember.* FROM tblMemberType RIGHT JOIN tblMember ON tblMemberType.ID=tblMember.TypeID WHERE " & GCriteria & ";"

Is this what you are trying to do http://www.allenbrowne.com/ser-62.html

[RLehrbass]

I am integrating this search system into my DB. It work exactly the way I was looking for.FormSearch2.zip
I will try your suggeste code and respond later...
Thank you again for your help. I have grown in access leaps and bounds through your time and assistance.

[RLehrbass]

Here is the final code I used to resolve the issue. I had to slightly adjust the code but it worked wonderfully.

Thank You.