G
Guest
Hi Deepak
The table is not sorted in that way - ok i "can" be but best to ignor the
table to start.
1st create a new form with your primary field (this can be hidden if you
don't need users to see it - this is a "very" good idea).
On your new form (call it frmEntry) put these fields
ID field
serialnumber
quantity
Then on your main form place a new button (call it ButtonEntry) with this
behind the OnClick event
Private Sub ButtonEntry_Click()
DoCmd.OpenForm "frmEntry", , , "[IDField]=" & Me.IDField
End Sub
Note the above code assumes that IDField is a number ??
Change the IDField name to what it is on your forms (it may be different
from the table name??)
your serialnumber field ascending. Use this query to produce reports/view
results/etc.
Hope this helps
The table is not sorted in that way - ok i "can" be but best to ignor the
table to start.
I want that, a user has to enter the fields(pop-up);
1st create a new form with your primary field (this can be hidden if you
don't need users to see it - this is a "very" good idea).
On your new form (call it frmEntry) put these fields
ID field
serialnumber
quantity
Then on your main form place a new button (call it ButtonEntry) with this
behind the OnClick event
Private Sub ButtonEntry_Click()
DoCmd.OpenForm "frmEntry", , , "[IDField]=" & Me.IDField
End Sub
Note the above code assumes that IDField is a number ??
Change the IDField name to what it is on your forms (it may be different
from the table name??)
Don't do this. Create a query (if you don't already have one) and sort byThen, I want output in the table as:
your serialnumber field ascending. Use this query to produce reports/view
results/etc.
Hope this helps