Search results for query: *

Cracked it - THANKYOU for pointing me in the right direction :) Me.searchSubForm.LinkMasterFields = "" Me.searchSubForm.LinkChildFields = "" Effectively resets th properties after selecting the records don't know why that started happening but it fixed it.

Debugging the code the offending settings are set when the record source is set: Me.[searchSubForm].Form.RecordSource = sq ' set record set based on results

Ah right the linkchild & master fields seem to be set once the search button is clicked for some very strange reason. Could I have corruption?

FindClient is a query that is basically a select all of the bookings table. SELECT Bookings.* FROM Bookings;

Gotcha, but no they are both blank. Any more ideas why this code is going wrong? It seems to be only search the current record not the whole table.

Apologies I meant "Record Source is blank" Subforms are linked by way of a SQL statement in hte record source are they not? In my case that field is blank - I also searched the project for any mention of LinkMasterFields or LinkChildFields and there is nothing. What am I missing

I don't think so the data source is blank. How would I check? Brain fart here, sorry :)

Hi all, I don't do this stuff much anymore but I have had a database in which I wrote a long time ago. Anyways I wrote some vb (with the help of this site) that creates a sring and sql based on search criteria and then sets the recordset of the subform to the results. However something...

Sorry I should have been clearer: This is what I have =OFFSET('Current week'!AY7,,wk_Incr-1,1,1) I want to make the "'Current week'!AY7" bit variable and set from a value in another cell. Say H9 = 'Current week'!AY7 I want to be able to change that if needed without reworking the formula...

Reviving this thread... How can I make the Original cell reference variable? i.e. To have a cell where you set the start cell reference Say Y1 = 'Current week'!FF6 Then adjust this formula to use the Y1 cell as the starting point? So you could adjust it to 'Current week'!YY6 and not have...

Geoff, You are a star!! Thank you that worked perfect. John :)

Hi guys/gals. Can anyone help? I need to pull value through from one workshhet to another but the range will change from week to week. What I have done to get the inital value is use the following formula and smartfill, but obviously it will need to be variable somehow.: ='Current...

O.k, done that and it is all blank, both on 98 and 2k. John

O.k here it goes... The main form is bound to table jobook It has 6 tab controls and various subforms bound to queries from jobbook and parcelcupboard (another table) all of which work fine. I then decided to implement a search form so what I did is created a blank tab control and moved it to...

Hi sorry for not being totally clear, JobNumber is on the Main for [Main] When a user clicks on the record on the subform (which is a cutdown record clone of Main) the code baiscly changes focus to JobNumber on the main form and searches for the records clicked [using jobnumber] Hope that...

Hi, Back after a back holiday. What the code is doing is..when the user clicks on the specified record in a subform which is based on a query which is based on the main table, the code then sets focus to JobNumber (which is an autonumber field) and searches for that record. This work fine in...

Seems to be a win 98 specific problem, --> Installed MDAC 2.6 + Jet Sp4 on target (Test) machine still no luck ????? What hte H*ll am I missing??? All works fine on Win2k and up but no 9x Cheers John

Hi oharab, I've tried all of the above to no avail :-(. Any more idea's ? in the mean time I'm going through technet putting patches on the test machine BTW It works when I run access with /runtime on my dev machine (win xp) but fails on win 98 without access (ie runtime) John

Hi hope this is in he right forum! I have the following code on an onlick event in a subform which searches the selected record and displays it on the main form.....it works great in Access 2000 / Xp but it doesn't work in Access 2000 runtime.??? I originally thought it would be a references...