clock1
asked on
Access Form
Have Form A contains a text field where user enters a string and stores string to memory variable.
Have Form B whose record source is Query B.
Query B returns the following records:
Class Color
1 Blue
2 Brown
3 Gold
4 Red
5 Green
User enters text in Form A. User clicks command button that opens Form B. Is there some way to open Form B to Color that matches string that user entered in Form A? Would like to navigate through all records in Form B, but open Form B to Color that matches string that user entered in Form A.
Know that I can filter on string entered by user, but that would prevent me from navigating through all records.
Have Form B whose record source is Query B.
Query B returns the following records:
Class Color
1 Blue
2 Brown
3 Gold
4 Red
5 Green
User enters text in Form A. User clicks command button that opens Form B. Is there some way to open Form B to Color that matches string that user entered in Form A? Would like to navigate through all records in Form B, but open Form B to Color that matches string that user entered in Form A.
Know that I can filter on string entered by user, but that would prevent me from navigating through all records.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
<but sets Filter On >
this should not happen, there is something going on in your form.
try this,
open formB in design view, click on the Data tab and look for the Filter property and delete the entry if theres any.
set the Filter On Load property to NO
save the form
this should not happen, there is something going on in your form.
try this,
open formB in design view, click on the Data tab and look for the Filter property and delete the entry if theres any.
set the Filter On Load property to NO
save the form
ASKER
Did as you advised, still shows Filtered.
ASKER
I clear everything in Filter property.
When user enters [Color] Access shows Filter property to [Color]=Me![Color]
Fetch Defaults and Order By on Load are set to yes.
When user enters [Color] Access shows Filter property to [Color]=Me![Color]
Fetch Defaults and Order By on Load are set to yes.
Rey's technique is the correct one to use for this circumstance. I would not be surprised to find some other code either in FormB or in FormA that is setting the FilterOn property of formB to true at runtime.
Can you post a sample database with only FormA, Formb, and the table and query that are used by FormB.
Best method to do this is to open a new database and import those 4 items. Then test to make sure that everything runs properly and that you can duplicate the problem in the new database. Then remove any proprietary or private data from the sample database, compact and repair it, and post it here.
Can you post a sample database with only FormA, Formb, and the table and query that are used by FormB.
Best method to do this is to open a new database and import those 4 items. Then test to make sure that everything runs properly and that you can duplicate the problem in the new database. Then remove any proprietary or private data from the sample database, compact and repair it, and post it here.
ASKER
I'll do so. Just quick comment:
After user enters [Color] on Form A, I open Form B using DoCmd.OpenForm FormB
After user enters [Color] on Form A, I open Form B using DoCmd.OpenForm FormB
ASKER
Found way to pass memory variable for Color from one form to next. Points are yours. Thanks!
Clock1,
What Rey told you to do in his post was to use the OpenArgs argument (the last argument) in the OpenForm method.
docmd.OpenForm "formB",,,,,,Me.txtColor
This is one of the many ways to pass a value to another form. You did not need to save that value to a variable, you simply needed to pass it to FormB usint this technique.
Dale
What Rey told you to do in his post was to use the OpenArgs argument (the last argument) in the OpenForm method.
docmd.OpenForm "formB",,,,,,Me.txtColor
This is one of the many ways to pass a value to another form. You did not need to save that value to a variable, you simply needed to pass it to FormB usint this technique.
Dale
ASKER
This load event locates the appropriate record and displays it, but sets Filter On so that I cannot navigate past the located record.