Where is the Data from Unbound Fields Stored in MS Access?

Question

There is a field in a form we currently have in Access called, "Date Product Shipped." For some strange reason, this was created months ago as an unbound field, instead of creating the field in a table first. Now we need that info for a query, but since it's unbound, the info hasn't been dumping into any tables. BUT the data has gotta be stored somewhere. How can we get at it in a way we can use?

Answer 1

An unbound data field, because it is not attached to any field in a table, etc. has no where to store its data. That's what an unbound data field is. So there is no way for you to query the data. You will need to create a field in a table to hold the data, and then bind the form field to the new table field. Then you be able to query the data by querying the table field.

Answer 2

It is not stored anywhere. The value in unbound field is discarded when form is closed.



Better luck next time.

Answer 3

if you're utilising this with a database, no longer an effective thanks to bypass. set up a first key integer, then a particular key combining very last call first call and dob or postcode, use the integer because the person id, this is a lot swifter to reference, and an basic analyze on the id promises the records to exhibit even as required.