Search results

Thank you Isladogs. How do I apply that query to a criteria box in my query. I am guessing I have to replace the criteria I have... [Forms]![frm_Testing_Status]![cbo_Status] Its just that I do have the same criteria but against 3 different fields in the query as shown in the attachment above.

I really appreciate the time and effort that you guys go to in replying to my post. Just to be clear - I'm not using a multi-value field - its just a Text field with values separated by a comma. Could I just ask though, what syntax I would use to just return a row from a query if a Number...

So if I had a field with 26, 30 29, 30 31, 36 I might want to return the rows that have 30 in them. The source of the '30' comes from the combo box. I tried this criteria but it doesn't work... Like "* [Forms]![frm_Testing_Status]![cbo_Status]"

I don't think these are the right solutions. I'm just trying to find a value within a field. So, if I had (and this is just an example), if I had a field with Fullname and Age (John Smith 45) and I wanted to search for anyone with 45 in that field, this is what I am effectively trying to do...

That looks untidy. How do I insert a table in here ?

Hi I have a table for Status Values... ID Status Value Preceeding_Status_ID 26 CV Received 0 27 Invited for Interview 26, 29 28 Rejected at Shortlisting 26 29 Interviewed 27 30 Rejected after Interview 29 31 Contract Offered 29, 32 32 Contract Accepted with Conditions 31 33 Contract Accepted...

I have 2 tables... Department Team The team table has a field (foreign key) for the Department that the team is part of. Department_ID Department_Name Team_ID Team_Name Department_ID (FK) The department is entered via a Combo Box on the form. This works fine. The Team is also entered...

and where do I put that line of code ? What event ?

So, Isladogs, so you mean the form where I am CHANGING the data or in the form that is fed by the query ? And that is your line of code above actually doing ? I've never used the DIRTY thing before.

It seems that if I click save after Ive updated the data that the query is run over and then go into the form - the additional records are there. So, how do I force a save in the source record set ? I tried DoComd.Save but I get an error.

I have a form which takes its data from a query. When that form is activated I would like the form to requery its data. I am using the OnActivate event but for some strange reason, the form isn't picking up the new record that is definitely there when I just run the query itself...

How do I suppress the #Error from the (New) record line in a datasheet ? Thank you in advance.

In the end I deleted the Split Form and started again. That seemed to fix the problem so all is good. A bit of a mystery.

Its a Number datatype

what is interesting is, this is a 2 part query to return the status related to a maximum date. The first part of the query is asking for the Candidate_ID even though the way I have built the criteria is correct. I really think this is a problem with Split Forms.

Please tell me isladogs

The builder gives me... [Forms]![splitform_RRARs_Approved]![frm_Candidates].[Form]![txt_Candidate_ID] still doesn't work

Can someone please tell me what is wrong with this before I throw this laptop out of the window... Cur_Candidate_Status = DLookup("Candidate_Status_Long", "qry_Candidate_Status2", "Candidate_ID = " & Forms![splitform_RRARs_Approved]![frm_Candidates].Form!txt_Candidate_ID) The Form names are...

I have a form that sits on a tab control. When I select the tab I would like the form and all the controls that sit on that form to requery, but what is the best Event to use in which to add the requery code ? Ive tried Form... Activate Got Focus On Current ...but none of them seem to work.

Gasman, in your split form - what form do you have at the top - the Single Form or the Datasheet ?