Search Main Form Based on Contents in Subform
The main form shows all the boxes. I originally just added the [BoxContents].[Contents] field to the main form and sorted the query based on what was entered in the text box.
The problem is there can be multiple content records for each box so it shows the same box over and over again depending on the amount of contents.
Thank you for taking the time to report an issue.
What's wrong... Please write below.
Now when I double clicked on to the searched item, it will show me the main form with the information that has been saved including the subform but it does not take me directly to the specific record in the subform.
For instance, In my main form, I have an option to choose A.M., LUNCH or P.M.
Accordingly, whichever one I click, it will be visible as a subform. For example, if I click A.M., the A.M. SUBFORM will be visible. If I click LUNCH, the LUNCH SUBFORM will be visible and the rest hidden.
How do I link subform to the search form so that if I click on to MR.A’s form for LUNCH time only, it will open up the main form with LUNCH subform.
This is what I have:
I want to create a form that has a main form with a text field that I can input a string of text and run a search on the problemtype field. And return all the results in the subform with based on keyword that was inputed in the form above.
I want the results to display Problem type and Technician fields. What is the best what to do this?
it is based on an if then statement based on a field in my main form. THe problem is that the code will not recognise the information in the subform until I leave the main form (or it loses focus) and come back.
Then my code works fine. I've tried DoCmd.RunCommand. AcCommandRecordSave and that didn't work.
I have added a combo box to the subform and I'd like to have it populate the fields in the subform, but still have the entire subform linked to the main form.
My first attempt was to assign the ID that was selected to a textbox on the main form, then automatically requery the second subform based on that value. I used this way on my search box. I'm sure there is a way to go directly from clicking the value to requerying the second subform, but I don't know it. If you do,
That being said even the indirect first attempt isn't working. It all has to do with the ".", "!", and ordering of this stuff. I'm not sure what . and ! mean. Cananyone explain them, It has to do something with Parent child, but beyond that I'm at a loss.
Me.[Collateral] = Acct_Reference_id
Me.[Navigation]![textbox] = Acct_Reference_id
I did find this very useful site [LINK]. It shows what code you can use depending on where you are and what you're doing. Even with that as a resource, I'm still at a loss.
CounterClaim_Appl.Value = Me!subfrmRep_Resp1.Form!ContacT.Value
me = mainform . subfrmRep_Resp1 = subform control . Contact.Value = contents of that field (I'm thinking)
I'm getting an error 2113 - Value entered isn't valid for this field, do I need to reference the tab control
What I want to have happen is on two unbound text boxes allow users to enter a date range and have the subform filtered to only show records of the date range entered in the main form boxes.
Main Form: VoucherMain
SubForm: VoucherDetail Subform
Field in Subform to Filter: DateTimeStamp Default Value: =Date()
Fields in Main Form used for Range: BeginDate & EndDate
Button to Apply Filter on Main Form: FilterTrans
When I run the Loan Search query with Search populated, it filters and works correctly. When I try to have it requery automatically, it doesn't seem to.
I have tried every combination of
Forms![Navigation]![Loan Search Subform].Requery
Me![Loan Search subform].Form.Requery
that I can think of. Some throw error messages. but no requery occurs.