Thanks so much for your time. I just figured out how to get to the answers to my posts!!! Ha Ha.
I did get the answer to this problem. You use the .column() subscript to refer to each element in the combo box.
Now I can look for answers to my posts. I appreciate your help.
I'm new so forgive me.
DeeDee...
deedeem
Last Activity: Aug 30 '07, 02:39 PM
Joined: Jun 27 '07
Location: Little Rock AR
-
access to word interface using a document with bookmarks
Hi there,
I am having trouble getting all my records to be placed into my WORD document from my ACCESS form. I have a form with a subform displayed and a control button that executes a macro. The macro just says runcode MergeToWord and the following is my VBA code:
CODE:
Sub MergeToWord()
On Error GoTo MergeToWord_err
Dim objWord As Object
Set objWord = Nothing
Set objWord =... -
By the way, I am having the same problem. My combo box has two fields from an underlying query called MMS and Rev. I want to requery the form based on these two values and only know how to do this for one value. My combo box has a name of Combo14 and I don't know how to refer to the values separately if you know what I mean. My code looks like this and worked when I just queried based on the MMS. When I decided I needed to query based on both MMS...Leave a comment:
-
Passing values to another form from a different form
I have a form with a subform called MMS Update. I have a button that brings up another form to add a new record. I then have a button on the add form to go back to the MMS Update form. I have tried using the builder on the button to open the MMS Update form and SetValue to the MMS Code of the new record so it will query it and display it for update but all it does is put the MMS Code in the form with data from the first record in the table. It still...
No activity results to display
Leave a comment: