Please Help: Find method and recordsets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have created a form called frmModify that is based on tblModify. Within the
form I have subform(called frmExisting). On the the form Modify, I have a
list box where users can pick a conveyor to modify. The only problem is that
the table Modify has many conveyors with the same name. The way I'm
separating this issue is that a project name and description have to be
entered. Within each unique project, the conveyor name has to be unque. This
works fine.

But all in all in my database i have several conveyor names that are the
same. When using my list box to select the conveyor that I want to modify.
It returns the conveyor BUT the conveyor that it returns is not in the
Project that I'm currently working on.

I think maybe the problem is the recordset. Looking at the code it's using
the FindFirst property. How can I code this to return the conveyor name that
correlates with the project and description that's being worked on?

I have a DAO database
 
There is no need to post your issue in every newsgroup. Do you really need
that many responses? Do you really think it is efficient for multiple
people to work on your issue when you may already have an answer in another
group?
 
Back
Top