Row data behind the scenes

[_jxdq]

Hey all,



I am enjoying this forum after browsing for the last hour. Looks like this will be my favorite for learning access. I’m a newbie with Access/Excel.


So, when a user types inside the form “this is a test for forums eyes” It will appear in the next row that has blank data. I was wondering how to create two columns, where behind the scenes can be edit or things added and the form data will start out at row 1 then go down? Instead of the next row that has no data.

[Minty]

Normally the form would be bound to the underlying table data.
You can open the form in data entry mode (If you go to design view and open the property sheet, it is one of the options on the form data menu), and it will automatically put you in to a new record.
If you open the same form in edit mode you would be able to edit the existing records.

[ranman256]

and sometimes if you are on a record, and at the last field,
move to the next field will cause you to move to a new record.

I filter single records, so the user wont move off into a new record.
form property: cycle=current record

[_jxdq]

Thanks for the response!

Problem with that then it overwrites the data in row 1..

[_jxdq]

and sometimes if you are on a record, and at the last field,
move to the next field will cause you to move to a new record.

I filter single records, so the user wont move off into a new record.
form property: cycle=current record

Thanks, I think all I need to figure out is the proper cycle, record locks and which command button and I should be good

[ssanfu]

When in Access, you should forget anything you know about Excel.
Access and Excel are as different and an Elephant and an Elephant Shrew.

Excel has rows and columns.
Access has records and fields.

I suggest you find an introductory course/book on Access before going any further...
Maybe work through these 3 tutorials (actually do the tutorials).
Access Basics by Crystal

And welcome to the forum...