By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,680 Members | 1,486 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,680 IT Pros & Developers. It's quick & easy.

Find record problem

P: n/a

I am having problem trying to go to same record when I close 3rd form.
I have a form called frmDepartment. This form has a list box that
displays all the departments. Clicking on one of the departments opens
up second form called frmEmployees. This form displays all the
employees for the department selected in frmDepartment. This form has
an unbound list box which retreives all the values from a query and
displays all the names of the employees. On the same form I have a
combo box which shows the names of the employees along with other
fields like age, gender etc. Double cliking on one of the names from
the listbox takes to the details of the selected employee. This form
also has a subform that displays the items bought by each employee in
the store. From this form I have a button that allows me to add new
employees for the selected department in frmAddEmployee.
The first problem:

When the frmEmployees loads I want the first record in the list box to
be displayed on the form. My combobox along with other fields shows
different employee name than the first record in the listbox where all
the employee names are displayed.

Second problem:
When I add a new employee, the new employee gets added and list box and
combo box also get updated but the problem is I have to search this
newly added employee in the list box. I want when I add a new employee,
the same employee record should be displayed on frmEmployees after
closing the frmAddEmployee.

Any help would be appreciated.


Mar 7 '06 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.