Search results

I won't say I completely understand what you did there (because I'd be lying), but I can see you declared strBuildFilter as String (not sure what that does) and then changed the "checks" for the drop downs. What exactly does "Chr(34)" do? Also, one other thing I forgot to ask, how could I...

Bump it on up!

Alright...I got the subform to display the text as it is written on the "Search Form", but when I try to search by Month, Year, Area, or Problems, it prompts for an entry instead of using the information I select/type in. Also, when I try to change the ControlSource on Area, Month, Year, and...

Hmmm...Must be doing something wrong here. I'll describe my steps and maybe you can help me see where I'm going wrong: 1) Open qryEquipment in Design View 2) Right Click > Show All Tables 3) Link all fields from EquipmentID_Table (Area, Year Complete, Month Complete, and Further...

That did the trick! I forgot to go back and create that field in the query for that form. Now, if I can just get the fields to display text instead of numbers for Area, Further Problems, Month and Year Complete. I remember you said this quite a few posts ago as a remedy for this problem...

Stilll shows up as #Name? even after I converted the field to a Memo (to fit the amount of text). I even went down the column and just filled in words, but it looked the same on the "Search Form" subform.

Both the Option Group and Option Group Control default values are blanked. They remain "grayed out" until data is entered into any of the other fields. I wanted to store it as a link to the actual file, so you could see the document that goes along with the record. Is that sort of thing not...

For some reason, I wasn't able to get that code to work, but I feel like a goober now. All I had to do was select the Subform > Data Tab > Change Allow Edits, and Allow Deletions to "No". I'm about <---> close to everything I need here. Just a couple more questions. For some reason, on the...

Hmm...still a bit confused. I used the Name of the container it's in (.sbfrmResults) in the On Load Event of the main form, but it doesn't lock the subform. Me.sbfrmResults.Form.AllowEdits = False Something I'm missing, perhaps?

Where would I find the name of this control? Also, would that go into the ON LOAD Event of the form or somewhere else?

HA! Alright...that's what I'm talking about! You, my friend, need a Paypal button, so I can donate my firstborn child. Is there a way to lock the subform so it cannot be edited? The "Locked" property didn't quite do it.

Hmm... Love how the debugger doesn't take you to the source of the problem :rolleyes: Pretty sure I inserted everything you had there Private Function BuildFilter() As Variant Dim varWhere As Variant Dim varProblems As Variant Dim varItem As Variant Dim intIndex As...

Here's the VBA code for the BuildFilter Function. Anything look out of place there? Private Function BuildFilter() As Variant Dim varWhere As Variant Dim varProblems As Variant Dim varItem As Variant Dim intIndex As Integer varWhere = Null ' Main filter varProblems...

Bump it on up!

Not a problem. Have to keep the priorities in order. :) Perhaps you can help me with another problem I'm having with the other form (that may be a bit less time consuming). On the "Search Database" section of my menu, I found this sample database that does exactly what I was looking to do. I...

Well, I'm all for doing it the right way the first time, so this thing doesn't go crazy on me for some reason down the road. I'm assuming your solution is somewhat similar to this from your website? [I tried doing this and screwed up the input form as I couldn't figure out which table to pull...

The ones that don't have autonumbers filled in are ones I filled in manually at the table level. When I try to use the "Add Record" button (after applying the "After Update" Event code you gave me to the form), it converts the fields with dropdown text into their corresponding autonumbers...

Thanks Bob...worked like a charm! One last thing, and I'll stop asking questions for a bit. For some reason, the month, year, area, and further problems continue to show up as numbers (corresponding to each's autonumber in their respective tables). How can I get them to show up as the text...

Any ideas?

Sorry, you're right. I did mean a subform on a form. :p I'm not sure exactly what the correct PK/FK combination is. I'll describe my steps and perhaps you can troubleshoot what I may be doing wrong: 1) Create Sub-Form with Wizard 2) Use existing Tables and Queries 3) Select "Table...