Search results

I have a combo that picks from one of 2 tables so I use a Union query to combine the choices. However, the primary key on both tables creates duplicate ID's in the bound column of the combo box. How do I know which table is chosen?

the field (control, sorry) has the focus. The blinker's in it. It just doesn't immediately highlight. It's actually a sub sub sub form but it is there.

I just want it highlighted to show it's the focus. Conditional formatting works well for all the fields when entering except that first setfocus. And sometimes it works....??!! Mostly doesn't.

When I Setfocus to a field from vba, the Hasfocus on conditional formatting doesn't consistently kick in. Is there a way to do this differently?

Option Explicit did pick it up. It wouldn't compile. I was blind.

I cannot believe I was so STUPID! I am not a newby! I actually thought I had copied it down because I wanted to check everything before I asked. I thank you so much for your trouble! Going somewhere to die now.

I get what you're saying but you didn't actually change anything from message #6 and I still get "Variable not defined".

The purpose here is to go to sfcInvItem.Description. When adding a new invoice I want items and not receipts.

Will this help...?

Public Sub FormFocus() Dim sf1 As Form Dim sf2 As Form Set sf1 = Me!sfcInvoice.Form Set sf2 = sf1.sfcInvItem sfl.SetFocus sf2.SetFocus sf2.Form!Description.SetFocus same error; same place Although this error (and code) is on the sfcCustDetail, this form is a subform of a main form...

Still same error. sf1 is a subform control and the form in the control has the same name

Public Sub FormFocus() Dim sf1 As Control Dim sf2 As Control Set sf1 = Me!Form.sfcInvoice.Form Set sf2 = sf1.sfcInvItem sfl.SetFocus sf2.SetFocus sf2.Form!Description.SetFocus Set sf2 = Nothing Set sf1 = Nothing at sf1.SetFocus I get a Variable Not Defined error This sub is called...

Arnelgp... Your code fixed the jumpy problem. Thank you so much!

Sorry, it shows all invoices for the customer. Click on the invoice and it shows the detail. Click on preview and it prints it out. No fuss. I only wish it wouldn't jump back to the first after selecting another. I shall try arnelgp's code. Just look at it once. By the way, I did look at yours...

Why? This works! Did you look at it?

I followed your instructions. It works and I thank you. However, I need to see detail on the other invoices from the same customer. How would I do that? This works, not? Don't you just hate it when people don't follow the rules?

Click in bottom subform to change invoice record.

I have a subform with record selectors. The following is the form on click event: Private Sub Form_Click() Dim rs As Recordset Set rs = Me.Parent.RecordsetClone With rs .FindFirst "InvoiceID =" & Me.InvoiceID If Not .NoMatch Then Me.Parent.Bookmark = rs.Bookmark End...

Wow! You went above and beyond. I design patterns for individuals. Thank you for your work. Completely unexpected! Is the bottom list of invoices a report? Is it in the footer?

Now I remember... I had to do that to keep it a continuous form. I didn't realize it would mess up my tabbing. Back to the drawing board... Thank you for your time.