working with unbound field in a form

[MediocreD]

Currently i am working on a db to track my poker playing while I play. I have created this form with a continuous sub form to list the games I have not updated the blank unbound fields that are pictured.

My first issue is every time I update one unbound field it updates all of them. I realize this is probably be a dumb question but is there a way to prevent that, or is my only real option to make the entire record clickable and pop-up another form to complete the MTT?

Secondly, I dont want the info to update until all the information is put in, so how do I use vba to update a table with the value of an unbound field

 

[theDBguy]

If you're using a continuous form, then using an unbound control (textbox) will simply display a single value in all the rows. If that's not what you want, they you'll have to use a bound control.

PS. Welcome to AWF!

 

[plog]

Why do you have unbound fields? Shouldn't all that data be saved to a table?

 

[MediocreD]

Why do you have unbound fields? Shouldn't all that data be saved to a table?

Those fields have not been updated and I dont want it to be updated until all the info is added.

 

[CJ_London]

you can use a calculated control - but just going out - there is an example on this forum under my name somewhere if you want to look for it, otherwise Ican find it in 4-5 hours time

 

[plog]

Those fields have not been updated and I dont want it to be updated until all the info is added.

So...don't update them? I still don't understand why they are unbound. Even if not unbound and you don't trust yourself to not update them you could lock/disable them on the form so they can't be updated.

 

[MediocreD]

So...don't update them? I still don't understand why they are unbound. Even if not unbound and you don't trust yourself to not update them you could lock/disable them on the form so they can't be updated.

its a matter of a lot of things happening at once.

I am playing 12-18 tables at one time and I have it set up to add those active tables with a click or maybe two. I dont get all the info at one time and I update wile I am playing and once I am finished entering the info I want it to update.

I realize now I went about it the wrong way and am going to redesign the subform.

 

[DHookom]

You could possibly make all of the controls unbound in a kind of matrix (like a spreadsheet). Clicking a button could then add a row/record to a table.

 

[CJ_London]

I’ll wait for the redesign before spending time looking for the link