Ian Wright
Registered User.
- Local time
- Today, 07:55
- Joined
- Oct 20, 2007
- Messages
- 28
I have an Order number register number, i.e. Order number 4564 etc kept in a table from which I have made an form.
When I want to create a new order with next order number I open the form try and take the number and put it in a variable called OrdNo:
DoCmd.OpenForm ("System")
OrdNo = [OrdNo]
DoCmd.Close
DoCmd.OpenForm ("NewOrder")
OurOrdNo = OrdNo+1
I have publicly declared the variable in the module and also tried to do so again in the module. I realise that this might be a bit of an agricultural solution be that as it may, any ideas why it wont load the variable please. :banghead:
When I want to create a new order with next order number I open the form try and take the number and put it in a variable called OrdNo:
DoCmd.OpenForm ("System")
OrdNo = [OrdNo]
DoCmd.Close
DoCmd.OpenForm ("NewOrder")
OurOrdNo = OrdNo+1
I have publicly declared the variable in the module and also tried to do so again in the module. I realise that this might be a bit of an agricultural solution be that as it may, any ideas why it wont load the variable please. :banghead: