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?
2006-07-13 06:32:32 · 3 answers · asked by orangeglow151 1 in Computers & Internet ➔ Programming & Design
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.
2006-07-13 06:42:06 · answer #1 · answered by dewcoons 7 · 0⤊ 0⤋
It is not stored anywhere. The value in unbound field is discarded when form is closed.
Better luck next time.
2006-07-18 13:37:34 · answer #2 · answered by D 2 · 0⤊ 0⤋
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.
2016-12-01 05:18:53 · answer #3 · answered by policastro 3 · 0⤊ 0⤋