Change field value with macros

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need someone to help me.
I created table with one field named “Num†as data type “Number†(Long
Integer, Decimal Places=0). In this field I put a number like 1234 as a
first record. Also I created a form with Text Box and Command Button.
With this button I want:
1.To take value from first record
2.To add 1 to the value (1234+1) and to record new value (1235) in new record
3.To delete first record (I want to keep only one record)
4.To put value of first record (previews new record) automatically in Text
Box.
 
In this field I want to generate following numbers which I’ll use for records
in separate forms and reports. As Example: I have separate “Invoice†and
“Credit†data tables, forms and reports in one project, but they haven't
relations among themselves. I need first “NumInvoice†to be 1234, second –
to be 1235 and if I create Credit record, the “NumCredit†to be 1236,
followed by NumInvoice = 1237 and etc.
 
Back
Top