Recent content by NightPort

Well I guess it isn't really a problem having the two seperated. But I would prefer to have them together. In my mind and for the limited time I have to work with the site right now. So having them together is the prefered meathod to me. Also I have been getting jerked around by the two I do...

Ok, I have just taken over a webdeveloping project for some of my friends who are starting an online magazine. Anyway, the person that was originally doing this for some reason has the domain registered at a place that doesn't host the site but points to a host. I don't like this idea at all. I...

Nevermind i just worked it out. Thanks a bunch.

Well Jon thanks for the quick response. Now I am curious as to which txtbox's After update do I put it on. So far it doesn't do anything at all. I have what you said in the after update in textbox1. Thanks again.

Ok, I know I'm going to sound retarded here, but with all this I'm doing for a search function I can't seem to figure out something I know is just simple as hell. It's killing me. Anyway I need to take a value that is entered in one text box, and add it to one that was entered in another text...

Alright everything is working on that. Now I just have to work on my calculation, but that is not difficult matter. At least I don't think it is. Thank you all for the help you provided.

I follow the norm. I will work with it in a little to see what I can, and I will check on everything you said to see if any of that works. Thanks for the patience

Well I tried the different things. Moved the code into the On Change of the combo box and I recieve this error now. Run-time error 2471 The expression you entered as a query parameter produced this error: 'The object doesn't contain the Automation object "RetentionField." My code is the same...

ok, that would work the best I think. I will work on that and get back to here when I need to work on this calculation if I can't figure it out. Thanks.

because I need the retention to make a calculation for another bit of information. I am not sure if I could do that if it was a column in the combo box. If thats possible then I can do it that way.

Private Sub txtRetention_Change() Me.txtRetention = DLookup("[RetentionField]", "[tblRecordMgmt]", "[RecSerNameField] = ' " & Me.cmbRecSerName.Column(0) & " ' ") End Sub This is what I have in my code. It no longer gives me the error, but it doesn't do anything else either. This...

I still get the #Error. I can't seem to get it to work no matter what I try.

OK I've modified it a little because I didn't understand why I did that. So here is what I have now. =DLookUp("[RetentionField]","tblRecordMgmt","tblRecordMgmt.[RecSerNameField] = Forms![frmAdditions]![RecSerName]") It still gives me the #Error though.

Ok, I have a Record Series Name, and with each name there is a corrosponding Retention. Now what I would like to do is lookup the retention based on the name that was selected in the combo box. I am pretty sure DLookup does this, but when I do it i am always getting a #Error in my retention...

I thank you Pat. I thought this as well, but my mentor project supervisor or whatever is pretty set in her ways. Hopefully I can convince her to see it the way I did.