Replies

http://link.brightcove.com/services/player…tid=21337502001

I don’t think my Schwinn could do that.

Stan Munro builds famous landmarks out of millions of toothpicks

I would like to have the toothpick supplier concession for Stan.

Priceless!!!!!

Thanks Wendell, I’ll look into this.

When my daughters started driving we put the following sign in the car window:

“If you don’t like my driving, stay off the sidewalk!”

Kitty would really love the laptop if you attached a mouse to it!!

The smurfs would go crazy with this.

Eureka!! I had to set the Data Entry property of the form to No. It was set to Yes.

Hi Mark,

I’m using a search form for this. Did what you suggested and the data is what it is supposed to be; frm_invoices is not getting filled in.

Hi Wendell, Thanks for the reply. Here is the code of the onClick event after I fill the combo box.
Private Sub cmd_FindByTrafficInvoice_Click()
On Error GoTo Err_cmd_FindByTrafficInvoice_Click

Dim stDocName As String
Dim stlinkcriteria As String

stDocName = “frm_Invoices”

stlinkcriteria = “[InvoiceID]=” & Me![Traffic-InvoiceID]
DoCmd.OpenForm stDocName, , , stlinkcriteria

Exit_cmd_FindByTrafficInvoice_Click:
Exit Sub

Err_cmd_FindByTrafficInvoice_Click:
MsgBox Err.Description
Resume Exit_cmd_FindByTrafficInvoice_Click

End Sub

Me!Traffic-InvoiceID is the combobox. This is a pretty straight forward approach that I have used many times.

That did it, Hans. Thanks a bunch.

Unfortunately, this did not work. The label and the text box are somehow connected and I can’t figure out how to disconnect them.

Hello again,

I think I may have stumbled onto a resolution for this. Instead of using tables as my input recordsets, I made queries and used them. Seems to have solved this problem.

If you have a parent and a child table there is no need for a junction table. A junction table typically joins 2 parent tables, e.g., a book table and an author table. The junction table would have, at a minimum, the primary keys from the two main tables as foreign keys, thus forming two one-to-many relationships.

In your case you could set up your primary table as is with PK1 as the primary key and then set up an athlete table with the athlete’s names, etc. with PK2 as the primary key. The junction table would include PK1 and PK2 as foreign keys plus any other information you need. Then create a one-to-many relationship between the Primary Table and the junction table and a one-to-many relationship between the Athlete table and the junction table thus creating a many-to-many relationship. HTH.

How big was the stadium?