Sorting Problem (1 Viewer)

[dcobau]

Also trying the form based on the query... the subform is not presenting me the new record with the defaults until I click on the row and type something.. then it fill the fields with the default values established making annoying the data entry.. for example if I type 125 the record automatically fill with 125$0.00 :S I have to delete the incorrect part which is the default value

that's where you need a button with code and proper field formatting

 

[elliot315]

dcobau thank you for you help, but now I have to go to sleep.. 2am and I have to be awake at 7am... really thank you for giving me direction... I'll continue this later in the day tomorrow, have a nice day, God Bless you.