e2cheng
12-14-2002, 07:43 PM
i'm a beginner with this access thing and looking for some help on a problem with obtaining the last record entry of a table.
current situation:
- i have one form and one table.
- on this form i have a 2 tabs which allow the user to switch back and forth between the ability to add a record and to view the contents of the entire table.
when i accept data from the user to input into a new record i need to read the last record entry and use a value in that record to calculate the next value to be put in with the present record. i am having troubles finding the last record without changing the record source of the form to a query.
another question on the side: if my form is linked to a query, is it possible to add to the table? if so, how would i do this??
current situation:
- i have one form and one table.
- on this form i have a 2 tabs which allow the user to switch back and forth between the ability to add a record and to view the contents of the entire table.
when i accept data from the user to input into a new record i need to read the last record entry and use a value in that record to calculate the next value to be put in with the present record. i am having troubles finding the last record without changing the record source of the form to a query.
another question on the side: if my form is linked to a query, is it possible to add to the table? if so, how would i do this??