Recent content by aikiai

I apologize if this has probably been asked countless times; however, in my search of this forum I could not find something that seemed to work for something so simple. ************************************************** Scenerio: I have 2 forms. The first form is my main form and the second...

Sorry RichO but you are confusing me. Earlier you stated the control source property is the value to get the data. Now you are saying this is the value to where the data is stored. So bascially where do I put the code to grab the data? Since you have now stated I use the control source to...

Thank you for your response. Yes I do admit my terminology is not exact and I do apologize for that. Okay so how do you get the values that are selected in the combo box and the text field to be "stored" into your "other table" Other table being the table that has all the fields with the...

I found this database on this forum that does what I want but again I don't "see" how it works. It does not seem to store the variable typedesc. [EDIT] Again this does not do exactly what I want. It appears it shows both the type and type desc in the combo box. I don't the person entering...

"my control source in my form. In the table there is a town field and a municipality field. " So how do you take the town combo box that is then updated with the municipality field to be stored in your "actual" table. I am assuming the control source is the table with the town and municipality...

I have requested this before but the example given did not fit my situation and I had a heck of a time trying to adapt the example given to me so I will step by step describe what I need. thanks... Can someone show me how to do the following: 1) Take a combo box that looks up a table that...

No problem. By the way, does this forum have any way to have stickys or some type of faqs that address common issues like this as I know this has probably been asked multiple times? Or is there an excellent online guide somewhere that addresses common how-to situations?

How does one have variables automatically appear if one is adding another record from a previous record. IE. My first record has ClientID and date. If I hit the add record button then how do I make it so the next record has the exact same ClientId and date? Thanks Eric

Someone once posted an database on how to do this but I was not able to see how they were able to automatically input the data into a text field. I know how to do a combo box to query and input those results into a combo box but I am confused how they got the information from the combo box...

How does one cause certain data to appear in another field based upon the data entered in another field. For example: I enter in the field the word "Carrot" in a field called food and the word "Orange" appears in the field color. And then if I enter the word "Beans" in the field food then the...

Okay I figured it out. Apparently there is a data entry lock on the form. Until I unlock the form for data entry then I get that error. Now I have a different problem. According to my goal I am trying to say if the race is 6 then popup a form. however what happens is that I get a runtime...

Any solutions? The only other table linked is by a common variable and the other table only has six variables. Is there something in the order that I put the code in my program? If I take out the save record statement then the button I created does the job I need it to do. Should I close the...

This code does not seem to work. I am at a lost as the popup box saids the SaveRecord not avaiable now. Just some additional background info. There are more then 1 tables connected to this form. I don't know if that has anything to do with it.

Can't figure it out. Here is the code: Private Sub Button_OpenQuest_Click() On Error GoTo Err_Button_OpenQuest_Click DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70 Dim stDocName As String Dim stLinkCriteria As String stDocName =...

I have created a quicky database that models my situation.