Search results

no they arnt spelt differently that was a typo i made in the code which i have now corrected but its still bringing up the same error. I have repasted it below DoCmd.OpenForm "Incidents", acNormal, , "[Incidents.VIncidentID]=" & Me!VIncidentID Form_Incidents.VIncidentID.DefaultValue =...

i have a form with a button which should load another form using the following VB Code: DoCmd.OpenForm "Incidents", acNormal, , "[Incidents.VIncdientID]=" & Me!VIncidentID Form_Incidents.VIncidentID.DefaultValue = Me!VIncidentID The form should then use a query to look for only those records...

Re: Code with this code below : DoCmd.OpenForm "YourPaymentsForm", acNormal, , "[YourClientIDFieldHere]=" & Me!YourClientIDFieldOnFormAHere can both fields be called clientid or do they need to have seperate names. I tried this before and had them set both with the same field name is this...

Re: Subform I would use a subform but there isnt anywhere else on the first form to put a subform thats why i want to use a button so it will open up a second form but still be relateing to the record i have just come froml.

I have two forms lets call them Form A which has my clients in, and form B which is going to show the payments made by those clients. how do i link them together so when im on form A say looking at client 1's details i can click on a button and then it will show Form B with only the payments...