open another form with same records.

[manic]

This is what Im trying to do, create a Cbo with employee names on a form and when the employee is selected all his records related to that form can be navigate on the secondary form. I tried the tutorial opening a secondary form with the same records but by God this is kicking my butt, i get all types of error, such as the table is in use by another user and stuff like that. any help on this will be appreciate it.

[pbaldy]

Since you haven't posted what you've tried, is this what you're after?

BaldyWeb wherecondition

If that's what you're trying, you need to post your code if you want us to figure out what's wrong. The table in use error might happen if you were opening two forms based on the same table, and the first one was dirty (unsaved edits).

[manic]

this is the code that i tried
DoCmd.OpenForm "Frmoperator", , , "[EmployeeID] = " & Me.EmployeeID & ""

[June7]

What is the result when you run that code? Error message (the exact statement), wrong results, nothing happens?

Is the combobox multi-column and the bound column is the EmployeeID?

If both forms are bound to the same table/query, that could definitely be an issue.

[manic]

the error was that the table was in use by another user.
now my questioin is the following, in order to avoid that should the secondary form then be bound to a query instead of directly to the table?
please be patient with me i'm learning as i go

[pbaldy]

Binding to a query on the same table wouldn't matter. Has the data on the first form been edited? It sounds like Access has sensed an issue with the same data being edited twice. Can you post the db here?

[manic]

yes sir. here it is.

[pbaldy]

The sample does not have the code you said was giving you an error in it, so I'm not sure what you want from us.

[manic]

sorry wrong one.

[June7]

Bad design to have two identical forms navigating the same records. Have one form and filter it. Review tutorials here http://datapigtechnologies.com/AccessMain.htm especially the one on Build a Custom Filter in Your Form in the Access Forms: Tips & Techniques section.

[manic]

Thanks June7 just what i needed to see. I appreciate all the help, I think i can take it from there.