Access Database help needed

[Moonstone6]

Hi All,

I use an access database at work. Basically i just want to add a new field on the records screen where i can enter a reference number. I thought i had done it but it keeps the same number i have entered on each record.

How do i make it so that on each new record the box is blank again so i can enter a new number (and it stays there)?

Thank you

[Haggisdj]

Hmmm from memory, I am presuming that the field that you want to add is already in the database?

If you have a newer version of Access make sure that the wizard icon is clicked in the toolbox when you draw the field onto the form. You can then select which field you want to bind it to.

[Moonstone6]

Well i created a text box where i wanted it but it has no event on it as all the events that are already on the system are on the same page so if i add it to this box it will edit the other field thats on this page (if that makes sense?)

Thank you btw :)

[Haggisdj]

I don't think it's an event that you want, you want the rowsource to be the corresponding database column.

[craft1948]

doesn't it work like excel.....click at top of column to highlight ...right-hand mouse click......click add column.....god it's years since I used access....

[Moonstone6]

Thanks Craft bt that doesnt sound like what i'm looking at here??

Haggis - how do i do this then??

Thank you :)