Hello,
On two of my forms i have them filtered to open to a certain person's information. On the form there is a drop box of all the people in the database. I want to be able to have the form open to my filtered name and then if i desire to look at someone else's record on the form i would select that record (via selecting their name) from the drop down menu and have the form refresh to The NEW person's information. If i put a requery on the combo box for name it doesn't work due to the fact that the form is still filtering based on the original filter when it was opened from another seperate form.
Maybe this issue can be resolved by having a box at the top where you would type in the name and the record would appear. How would I go about fixing this?
Thanks in advance!
Marie
On two of my forms i have them filtered to open to a certain person's information. On the form there is a drop box of all the people in the database. I want to be able to have the form open to my filtered name and then if i desire to look at someone else's record on the form i would select that record (via selecting their name) from the drop down menu and have the form refresh to The NEW person's information. If i put a requery on the combo box for name it doesn't work due to the fact that the form is still filtering based on the original filter when it was opened from another seperate form.
Maybe this issue can be resolved by having a box at the top where you would type in the name and the record would appear. How would I go about fixing this?
Thanks in advance!
Marie