Search results

Worked perfect. Thanks both for suffering through my long explanation :) and @Brian, I think in this case it was learning to read faster haha. I had quite the essay

I have a table called Inflation Rates and one called Project Info. Project Info has the field "Date Completed", and Inflation Rates has "Date Year" and "Cost Index". My first query is called "Project List Query" which has the fields "Project Info.*" as well as the calculated fields: Year...

OK, so I made an executive decision and reworked the structure of what I am trying to do in my grand scheme. So, I solved this problem by replacing the issue. My new setup works much better, but I'm having a small issue, which I'll outline in a new thread here...

So my main form is a marketing contacts viewing form, and in this I have a subform which has a list of all contacts in the database (its a small one). The subform is a continuous form formatted like a datasheet, so I can view essential data for multiple contacts at a time, while still allowing...

I believe that part is correct. I used DoCmd.SearchForRecord acForm, Forms![Marketing Targets]!MarketingTargetsSubform.Form.Name, acFirst, "[Contact ID]=" & TempVars!ActiveControlValue where "Marketing Targets" = main form "MarketingTargetsSubform" = subform control name (container)...

Well, that fixed my syntax problem, for which I am very grateful. But now I have a new error: "The object 'MarketingTargetsSingle' isn't open." Where "MarketingTargetsSingle" is the object name (not control name) of my subform. Except it is, it is loaded when I open the main form, and I can...

Ok so I tried DoCmd.SearchForRecord acForm, Forms![Marketing Targets2]!MarketingTargetsSubform.Form.MarketingTargetsSingle, acFirst, "[Contact ID]=" & TempVars!ActiveControlValue where "MarketingTargetsSingle" is the object name of my subform, to no avail. The error message now reads...

I'm not sure if it's a typo, but off the top of my head I can tell you "Elseif" is supposed to be "Else If" (There is a space). That would certainly mess up your code...

So I have a main form, and in the header I have a combo box where a user can search for contacts, but I want the box to search for records in a subform, not on the main form. On the combo box's After Update property I have this code: Private Sub cboNameSearch_AfterUpdate() On Error GoTo...

Thanks a lot guys. Its been ages since I used continuous forms, I had completely forgotten about them. Using that method will also open up a few other functionality items I was grappling with. Appreciate the help.

Correct, however when I put a button in the details section, it doesn't display in the datasheet subform on my main form

No, not really. :/ I already know how to do that, and have implemented it several times in this database. What is stumping me is how to reference a highlighted record in a subform. So, using your code, DoCmd.OpenForm "SecondFormName", , , "FieldName = " & Me.ControlName would work, except...

I have a form, Marketing Targets, which pulls records from a simple table that contains a field called Contact ID (key field). This form has a subform, Action Items subform, which also has the field Contact ID. The subform displays records that share the same Contact ID with the current record...

Very true. All programs have their quirks, Access included. Emily, how is your field set up? At the moment is it stored in a separate query/table, which you then access in a different query? Or is the calculated field located in the same query in which you are trying to place a criterion?

Ahh, really don't know why I didn't think of that before. I was just so set on using the field names as a text formula. Thanks a bunch, that should work fine.

Well typically when you have a calculated field, such as hers, the value is stored for use as soon as it is calculated, therefore it should be immediately accessible to use as a criteria. for instance creating a field in a sales table IIf(AnnualSales/12>1500, "Good Salesman", "Bad...

This sounds like a query is not what you want...the problem could easily be fixed using a simple VBA function, using an if statement i.e. If Forms!Form_1!MyField <> Null Then Forms!Form_2!MyOtherField = Forms!Form_1!MyField End If

Is the field with the IIF statement located in a query or a table? And you say that the field does store the value returned by the IIF statement? If this is the case then any criteria statement should function fine; the value returned by the IIF statement is a simple text value. Finally, have...

I'm attempting to use a text formula as a field name in a query. The scenario is this: I have a field named Design Phase, and also three named GMP Owner Bid, DD Owner Bid, and SD Owner Bid. Design Phase is a lookup field, with three possible values (GMP, DD, and SD). See where I'm going with...

worked perfect. appreciate the help.