I like to see what was done can you share the database so I can see.  No promise but will give it a shot.

V/r
Juan

Hi Juan , yes I can  share this database with you. What is your email ? Thanks in advance for your help.

Regards
Graham

Not reviewing the video lessons, so hopefully I'm not shooting this way out into left field. Just assuming what you mean. If you mean it has no record source. I don't think you can do that with an unbound form. It has to have some way to link the list to the form. I use a code like this, I don't remember what lesson but I got the basics of it somewhere along the way in the dev classes.

Private Sub CustomerList_DblClick(Cancel As Integer)
    If IsNull(CustomerList) Then
    Exit Sub
    Else
    DoCmd.OpenForm "CustomerF", , , "CustomerID= " & CustomerList
    End If
End Sub

If yours is similar to this, it will never return a valid customerID because it's not bound to any table that has the ID in it.

Hi Adam thanks for the reply, it is not working because the ALL the text fields in the Customer form are unbound.
Already try that option:
If IsNull(CustomerList) Then
    Exit Sub
    Else
    DoCmd.OpenForm "CustomerF", , , "CustomerID= " & CustomerList
    End If
End Sub

Any other solutions from your side?
Regards,
Graham

Why is is unbound?

To open an unbound form based on a customerID in the list box, you'd have to tell it what values you wanted it to load. The easiest way (I don't suggest, this is way overcomplicating it) to do that would be to make every unbound field a DLOOKUP based on the ID from the previous forms search listbox. I'd just make them bound.

Hi Alex, the Customer Form are base on Developer 18 lesson 4 and 5. The record set for the customer form works 100%. Need to be able search for the customers in that form, even with another customer search form. Hope you can help? Regards

Dev 18

But why are you doing it this way?
Lesson 4/5 was just a way to show you an example of how to use RSs

Why would you not bind the CustomerF to the CustomerT/CustomerQ?

Usually you'd have a search form and when you select the Customer you want you can open the single form with all its data.

Ah this lesson was recordsets, my answers were only slightly into left field then :). But yea, unless you have some strange reason, I'm with Alex, just bind it.

Already tried the CustomerF to the CustomerT then received numerous errors like duplicate indexes. First when create the customer form that link to CustomerT it works fine then after while give Index error messages, that is the reason why want to  use RS

Is CustomerF a single form?
Is this one youve made yourself or one from the Template?

If you don't get it solved here in the forum and want to send it to me I'll take a look later tonight when I get some free time. Unless Juan is already looking at it.

[email protected]

Thanks Adam, can I send the database tomorrow to you. Will send you the customer form with the search form , is that okay?  
Alex I used the template and based the customer form on it.
Thanks guys for your help in advance

I'm here if you guys need help.

Yes, that's fine. You can send it to me or Juan, we will help if we can.

Thanks guys, will forward db later