Search results

Still getting the same problem. :( This is the current code, based on how I understood Pat's suggestion. I bolded the 2 places I change Me.SRNumb to Me.Name. Do I also need to do something on the secondary form (the one I'm trying to call)? -------- Private Sub FSRAddComment_Click() On...

OK, still having problems. Sorry I haven't looked at this in a couple weeks as I kinda got sidetracked... Anyway, Lyn, I think I need the "Dim OpenArgs...", as when I removed it, I got a message that the form wouldn't load as it was read-only. Here's my current code.. ------------ Private...

OK, I'm tinkering w/ it as well as looking for other examples from other threads. My code is now: ---- Private Sub FSRAddComment_Click() On Error GoTo Err_FSRAddComment_Click Dim stDocName As String Dim stLinkCriteria As String Dim OpenArgs As String stDocName =...

Pat, I'm unfamiliar w/ OpenArgs, but I did try and figure it out from the help menu, but I didn't get too far. Here's my code from the button that summons the pop-up: --------------- Private Sub FSRAddComment_Click() On Error GoTo Err_FSRAddComment_Click Dim stDocName As String Dim...

DBL, What you suggested wasn't working for how I was envisioning things, but it gave me pause to reconsider how I was gonna do things, so, now it is working and I did use your ideas and I'm happier w/ it. So, tx very much! :)

Apologies Tim, I realize I may have mistated how the subform is called. Its called by a button on the first form. Sorry about that. Hopefully someone can point me in the right direction.

Looks like you may have it solved, but here's my simplistic idea... (I tried to post this earlier, but the BB is pretty slow for me today) ---I'm pretty new to access, but I think your answer is easier than you think. I have a db where I want to make sure that people are using the correct...

Tim, Thanks but that didn't work. I changed the value in the text field of the subforum to: =Me.Parent![SRNum] FYI, it changed it to this: =[Me].[Parent]![SRNum] And in the end, it is not picking up what I need it to. Other suggestions? Or maybe I did something wrong from your idea?

OK, I have to forms that load the same subform. The subform, FSRComment, has a text field "SRNum". The text field is supposed to get its value from the the form that loads it. I put this line in the Default Value box of the text field: =[Forms]![FSREdit]![SRnum] Or...

Well, both fields are from the same table. They do have a 1-to-1 relationship, if that's what you mean. I will try and do as you suggest later today/tomorrow and see what it yields. In the mean time if anyone else has any thoughts/suggestions, I'm game. Thanks DBL!

It is a number, but its not an autonumber.

In the form I'm working on, I have 2 combo boxes (they could be list boxes too, I don't believe this part matters). The first is a list of project descriptions, "projects". You select a "project" and it requeries the 2nd box to pick the appropriate project number, "projectSR", for the "project"...

Understood. Thanks PDX! :)

*bump*

PDX, Thanks it runs w/out error, but is not returning me anything. At this point, I'm sure its just me not knowing/understanding a couple things. May I ask a couple conceptual questions that will help me maybe figure this out? In the whole "case" section, do the 0, 1, 2 correspond to the...

I shoulda made it clear (I usually say this w/ my other posts) that I'm just learning "code" and what all the syntax is, so you have to be very specific with me. :) I did add the line that RV said and this is what I have now: --------- Dim stDocName As String, stDocWhere As String...

I added the "'", but the code never gets that far. Its hangs the first time it sees "FilterStr" and gives me "Compile Error: Variable not defined" :(

*bump*

Questions: Does the "Case" have to correspond to the values of my option group? (which are 1, 2, 3, not 0, 1, 2). I wasn't sure what the purpose of the textbox was. I'm guessing this is where it gets the value to filter on? You suggested an Option Group, which I called "SRtypeopt". It has 3...

I have 3 nearly identical queries running that, in turn, are ran by 3 nearly identical reports. Everything is the same in regards to what fields/data to pull for my report. The only difference in the reports is which query they call. The queries SELECT, FROM, and JOIN statements are...