Search results

Are the subreports linked to the main report? Because you would only need to filter the main report from the Form, i.e. If your field is numeric... DoCmd.OpenReport "YourReport", acViewPreview, , "[FieldInReport]=" & Me![ControlOnForm] If your field is text… DoCmd.OpenReport "YourReport"...

Hmm, I would try adding an Else part, i.e. Else DoCmd.CancelEvent That should *capture* the clicking of the No button.

Is the button in the Form Header or on each record?

Correct because there is no Customer ID of 0 so you can't use that in Torders. Referential Integrity will prevent you from entering a Customer ID that does not exist but it will not prevent you from not entering a Customer ID. You need some sort of *other* validation for that.

Referential Integrity is to ensure the data from Tcustomers is available to Torders and exists in Tcustomers. It does not prevent you from not entering a customer. It only prevents you from entering a customer that does not yet exist. So you can make Users entering by setting up validation on...

But they did. There was one that was in the news in 2018 for doing just that. The Supreme Court eventually sided with the Baker. IMHO, I believe that was the beginning of the slippery slope... and now we are here sliding down that slope at full speed.

@june I will agree with that. It is one of the reasons I think the tables should be adjusted.

1. Not the way to do it. You should create a junction table between the Stock and Customers to store those details. You will create a nightmare if Customer 1 wants to purchase a product used by Customer 2. 2. Don't wait till later, fix it now. You always get the foundation correct before moving...

@June7 Yes, I did and tested in that version. As soon as I changed the Data Entry all was fine. Hmm, may have to fire up the Access 2003. I got some old databases around here somewhere.

This might vary depending on what version of Access but Data Entry set to Yes on a continuous subform would do exactly what I saw. What version did you test in? Just curious because I would like to try it and see what happens.

Hmm, I got more questions: 1. Why is Customer ID in StockCodesT? If that's the stock\inventory then there should be no Customer ID in there. 2. DeliveryAddr1, DeliveryAddr2, DeliveryAddr3, etc is a red flag. If there is more than one Delivery Address they should be stored in a separate table...

On your continuous Form in the Properties Window set Data Entry to No. Having it set for Yes will always make it go to a new record allowing for Data Entry only. Side, note: I had to remove the filter on the combo box in the subform as I kept getting errors. I also don't quite understand the...

Yeah, well tabbing between two Forms and\or Tabs does require VBA. However, If I understand you correctly you really want them all on one Tab (of Form). Did you consider moving the controls around and putting them where you want them? Or is that not something you want to take on?

You are correct, will do my best to remember that! We were ALL beginners once. 🙃 In image TabControl2.jpg, that appears to be the one you want to fix. First select Auto Order at the bottom and then review the order. If not what you want, click on the one you to move and then hover over the...

Hmm, well that is odd. How are the Form\Subform linked?

They are separate, one is the Tab Order for the Tab Control and the other is the Tab Order for the Form. So, what are trying to change the Tab Order of?

Are you sure your Subform is set for Continuous? Because it looks like it's set for Single which would explain that.

There might be some event in the On_Open, On_Current or On_Activate event of the Form that is setting the order. Have you checked that?

Glad to help 🙃

Sometimes people forgot to delete old useless lines. So, with that in mind, make a copy and then delete away. Also, you can *spot* unused sections of code. If you click in between Private Sub and End Sub and at the top on the right you see something like Private Sub DeleteCurrentContact_Click...