Search results

This link may help: http://access.mvps.org/access/forms/frm0031.htm

@Tony I looked at your video. What a great feature you created.

As you gain experience in MS Access you will discover other methods to pass values between forms. I prefer the one I used because it doed not require the form to know anything about who launched it. It is more modular that way. :)

For the record, bound Control means it has a ControlSource, bound Form means it has a RecordSource. Basically when you change the value it is changing the value in a table somewhere. Unbound, that is not the case unless you do the changing yourself. If the 1st form is displaying the "Comments"...

Check back tomorrow. We need to cover a couple of additional things. Go home for now and I'll leave the posts for you to read later.

BTW, does the ComboBox have a ControlSource (Is it Bound)?

Private Sub Form_Load() Dim strOpenArgs() As String If Not IsNull(Me.OpenArgs) Then strOpenArgs = Split(Me.OpenArgs, ";") Me.cboNameOfComboBox = strOpenArgs(0) '.. If there were more arguments ' Me.txtAnotherTextBox = strOpenArgs(1) Else ' .. Do something else End If End Sub

Queries take up very little space in a db as they are just the SQL and some strategy. Let's modify the Load Event code.

If you are not using queries as a record source for your forms, you should be. It will save you from some locking issues later on. Okay, let's add a Load Event in code to the 2nd form. Use the same method you did to add the click event to the 1st form button. Show the form in design view. Show...

BTW, Colin Riddington (Ridders) is a new friend I've made that creates remarkable software. He's on your side of the pond as well. :)

It depends on how you want YOUR system. They did press the add a comment button to this project, right? What is the Record Source of this 2nd form? Does it point to the same table as the 1st form? Are you using queries as a record source or just tables?

See ya! You're welcome to butt in any time you want. :)

Good. Now why are you using the ComboBox on the 2nd form?

Hi Ridders, I'm sure it would and I have TeamViewer but then others on the forum lose the benefit of the exchange.

You still with me?

Once that's done we'll work on form #2. I need to understand why you are using a ComboBox on this form.

This change will not make any difference to how it runs yet. I am a real lousy typist if you hadn't figured it out yet.

My boo boo. That should have been TO not yo.. :(

Everything we've done so far is to the 1st form.

Okay, lets pass the project_ID to the 2nd form in the OpenArgs argument. Change this line: DoCmd.OpenForm stDocName, , , stLinkCriteria yo... DoCmd.OpenForm stDocName, , , stLinkCriteria, , , Me.project_ID This assumes the value is in a control named [project_ID]