Search results

I have this as my criteria (see attachment) That's the name of the form and that's the name of the control. The same approach works on a Single Form but not on a SPLIT form.

Hi I have a query which takes its criteria from a control on a SINGLE FORM and it works fine. If I then edit the query so it takes the criteria from a SPLIT FORM it no longer works. Does anyone know why this might be the case ?

I created a split form which opens fine on its own, but when I drag it onto a tab, its only showing the single form and not the datasheet. Any ideas why ?

Yes they are 2 separate forms on the same parent form. Each form (a datasheet and a single form) have the same data source. This is because the users wanted to see an Excel/table type view and when they select a particular record on the datasheet, they want the single form below it to jump to...

Hi I have a Single Form and a Datasheet on a form which hold the same data. I sometimes need to filter the datasheet and select a record and then have the Single Form jump to that record. This isn't working using ... DoCmd.GoToRecord , , acGoTo, Selected_Candidate ...so I want to return...

I didn't know there was a builder to build VBA code. I switched round the Requery and Refresh statements and it seems to work. But, it seems I have to set focus on the form in order to Requery it. Is this correct or is there a way of requerying the form without setting its focus ?

Hi I'm adding a record to a table and then I want to be able to see that record in the Datasheet form but its not there. I have to select the datasheet and then click refresh for it to appear. I've tried refresh and requery but nothing seems to work...

Sorry, wasn't meant as a criticism just wanted to help any future readers of this post.

OK, I've got it to work by adding the criteria argument that Gasman added (but had to fix the error he'd made. the Dlookup should have been... =DLookUp("[MinOfStart_Date]","[qry_Initial_Start_Date2]","Spot_ID=" & [Spot_ID]) However... In the New Record row, I'm now seeing #Error. How do...

I had created an aggregate query first. That is shown in my screenshot. This is then used in my second query which I show in my first post.

Gasman, should you last argument include the UNDERSCORE between Spot and ID ? Spot_ID Because I've added this and I now get a #NAME? in the field.

Colin, that is exactly what I have.

Ive copied the last argument in but its now saying its Invalid Syntax.

Even though INITIAL START DATE isn't actually in the Contracts table ?

Maybe I need to understand what an AGGREGATE query is.

Colin, isn't that what I've done ? See the screen shots.

Hi I have a table of staff with (for simplicity)... Spot_ID (this is the Staff ID) Full_Name Initial_Start_Date and other stuff... The 'Initial Start Date' is the start date of the staff member's very first contract using this Dlookup...

I set the Source for the Textbox as the field in the query... =[qry_Candidate_Status2]![Candidate_Status_Long] but when I load the form the Textbox just shows... #Name?

And how do I do either of those ?

Thank you. And how do I then pass the status to a text box on the parent form ?