Keep temporary Data using Text Box in MS Access form

Question

Hi, I am creating a database for the warehouse using MS Access and I need to store temporary information for each Item in Access form, so every time I open the form, the temporary information is there and it should be different for each item.

Many thanks in advance for your enlightenment and God bless you.

Cheers,

H.G

Answer 1

I don't quite follow this. If you have data associated with an item it should be part of the item record.

Answer 2

You need to create a field of the appropriate type in the table that stores the item data. For example, if the temporary data is a currency amount, create a Currency field, or if the temporary data is text, create a Short Text field (max length 255 characters) or a Long Text field.

On the form bound to this table, create a text box bound to the new field.