Search results

@pbaldy Hmm, so not that I know of... missed that completely.

And I second @gemma-the-husky when it comes to combo boxes in tables. No End User should have any interaction with the table so no need to put combo boxes at that level.

Hmm, use a Query as the Recordsource and then you can sort on the Customer ID and never have to think about it again.

You will need to adjust to fit your Control names and Row Source data but this should do the trick... Private Sub cboSearch_KeyUp(KeyCode As Integer, Shift As Integer) If Len(Me.cboSearch.Text) >= 2 Then Me.cboSearch.RowSource = "SELECT epEntityID, ecValue FROM qrySearch WHERE...

Okay, well that's fine. Hmm, not sure I get that but if you create a query that gives you the results you want on the Form you can then create the Form.

Thanks for that, never bothered to see if that still happens.

Hmm, are you talking about lines that start with *Private Sub...*. If so, then they don't really *write themselves* but they do appear if you select Event Procedure from the Properties Window and will stay there even if you put nothing there. They do not *clean up* by themselves unless you...

Hmm, a little concerned about those Relationships. Should be more like... Incident Log > Incident Log Details Incident Log Details > Incident Log Students OR Incident Log > Incident Log Students Incident Log > Incident Log Category At which point you could use Main Form > Incident Log and...

You should really start a new thread. This one is 8 years old and won't get the attention it deserves as only the people within this thread will your post.

Hmm, maybe this will help... https://regina-whipp.com/blog/?p=704

This might help... https://access-diva.com/blog/?p=392

Outputting to queries won't work as you STILL need a way to tell it where on the Template to go.

Hmm, perhaps this will help... https://www.access-diva.com/vba13.html It pushes the User back to the control that needs required information. If you want to cancel the entire entry the code will need adjusting.

So sorry for delay, work just went crazy. You are using... I do not use that so I do not know of a way to specify where on the Template to drop it. Using code is the only I for that with which you can specific what row and\or column to start placing your data.

Hmm, can't even think about this till tomorrow, getting ready for a conference call.

Hmm, the UA went offline recently while they updated, that might have caused people to look for other Forums. :unsure:

Welcome to the Forum!

Welcome to the Forum!

Umm, nothing for me to evaluate as I have been doing this for quite some time which is why I replied to Hilary that way.

Hmm, again a query with a parameter must be saved first or it will error out. Also the line you recommended is for older version so not recommended.