Recent content by Riru

Thanks bob fitz... although I already knew that it seems I needed reminding. Next question, How do you assign a macro/code to this control?

I have placed an unbound subform on a form. I have the following code which loads in different datasheet to the subform: 'Loads in NewQuery Me.data.SourceObject = "query.NewQuery" 'Loads in NewQuery2 Me.data.SourceObject = "query.NewQuery2" etc.... this works fine to show these queries but i...

Hi yes CazB. To explain further: Table 1 (tblOne) has Fields [Batch Number] and [Release Time/Date] Table 2 (tblTwo) has fields [Problem/Issue], [Time/Date], [Batch Number] I want a macro to search tblOne to find the [Batch number] which occurs before [Time/Date] in tblTwo.

Thanks for any help. I have a database which tracks product batches test results and then any reported issues. I have one table tblOne with [Batch Number] and [Release Time/Date]. The 2nd Table tblTwo [Problem/Issue] at [Time/Date]. What i need to do is get the last batch number from table...