Find Record to Edit?

[rc-alex]

Hello,

I didn't see a whole lot in google searches, assuming I'm searching the right term. What I need to do is offer a couple of combo boxes to narrow down results of records (I can do this) but then, based on the results that are left, allow the user to select a record to edit? How can I acheive that part?

Thanks!

 

[bob fitz]

Why don't you use a combo box for the final record selection?

 

[rc-alex]

Ok, That would work. Then I guess set a tempVar and open that record somehow in a new window?

 

[bob fitz]

Hi rc-alex

I'm not sure that you need to open another form.

Can you answer a couple of things:

What I need to do is offer a couple of combo boxes to narrow down results of records

Are these combo boxes on a bound form?
How do you show the records that are left after a selection has been made in these combo boxes?

 

[rc-alex]

Bob,

Not sure about the bound question.

As for showing the records, I wanted to be able to select like this:

DivisionID
(filters next combo)
StoreID
(filters next combo)
EmployeeID
[Edit Employee] <-- cmd button to open frmEditEmployee

 

[bob fitz]

Hi re-alex

A bound form is a form that has a table or query as its' record source. It shows each record in table/query. An unbound form doesn't usually show data because it has no data to show.

I am guessing that your form is bound to a table that has details of employees. If so you could use the After Update enevt of the 3rd combo box to set a filter on thw current form so that it only shows that one record, or you could use the same event to move to the record that matches.