Limiting Rows By Given Number In Continuous Form (1 Viewer)

[vbaInet]

Nope! It's a form event. Look at the events on the form. Remember it's a Delete action too.

 

[vdanelia]

You Mean On Delete Event

 

[vbaInet]

Good job but not 100%. You need to put it in the After Del Confirm event of the subform.

In the code you will need to change the reference to the form slightly. See what you can come up with.

 

[vdanelia]

I never used that event before and why should to use it now?

 

[vbaInet]

Click on the event and hit the F1 key. Read the help files about it.

 

[vdanelia]

I read it carefully but nothing Important for me there

 

[vbaInet]

You don't understand why you should use the After Delete Confirm event? It just means that the code will fire after the record is deleted.

 

[vdanelia]

You don't understand why you should use the After Delete Confirm event? It just means that the code will fire after the record is deleted.

I know that, After Delete Confirm event occurs after the user confirms the deletions and the records are actually deleted or when the deletions are canceled...
But my problem is another thing not the deleting the records!

 

[vbaInet]

Oh I see what you mean!!!!!

Is quantity bound to field? I mean is it an unbound textbox?

 

[vdanelia]

Yes Quantity is Bound with the field

 

[vbaInet]

Should quantity not be an unbound textbox?

 

[vdanelia]

Quantity is not an unbound text-box
It is bound text-box based on a table

 

[vbaInet]

The question is, are you sure it should be bound?

 

[vdanelia]

This is a new database, I have not the records, I'm building it and testing...
No I'm not sure
I can make it unbound if you suggest it.......

 

[vbaInet]

Cool

Is the Quantity supposed to be a count of how many records are in the subform?

 

[vdanelia]

Hello VbaInet
The Quantity is counting and giving me a Total Sum for example: (Unitprice * Quantity = SumAll Giving a result)
I think that it is a normal

 

[vbaInet]

If the Quantity field is not directly related to your subform's recordset, I see no need to update it. It defeats the purpose of what you just achieved.

 

[vdanelia]

Hello vbaInet

Here is my new test database. please check it and suggest me if something is not correct (Table normalization, relationship)

Thanks Advanced
By the way i can create a new thread for this new test database Just for suggestions

 

[vbaInet]

I've just had a quick glance and I can say that you have some good normalization in place, so well done!

I will just point out two things:

1. In the Relationships I noticed you made them all OUTTER JOINs. This shouldn't be so. You should avoid Outter Joins in the Relationships window and if you need an Outter Join just do it in a query.

2. The SumAll field should not be a field in your table. It can be calculated in a query.

This is just my 2 cents I don't have much time to go into too much detail.

 

[vdanelia]

Thanks vbaInet for the suggestion
1. Which one to use then from join Property, 1, 2, 3
2. OK I'll Remove the SumAll from the table and will do it from query or Expression

Thank You very much for your help!