Rookie Questions related to data entry

[weapon3000]

I have designed a window to enter data into the records of a specific table.

1st Question: How to program the window so the actual record to be altered is untouched unless I click the save button (I designed a command button to perform this function)? I really want this only after I click the save button, so I think setting recordlock to 1 wont help.

2nd Question: In my design, I used several combos to allow me quickly select a value instead of type it manually. The problem is there are more selections than I needed, some of them are repeated; e.g. I only need to select either A or B, but I can find A B B pop out from the drop-down. How can I remove those self-repeating terms?

By the way, the queries behind the combos are directed to different columns in the specific table where they have repeating values (column designed for classification purposes). Should I create another table to handle those classification terms and direct the queries over there?


Thank you for any kind suggestion!

[NTC]

1. save button: No such thing. client/server DBs are 'live'. A common question however because of users in the web server where they send data back to the web server. Not the case here. In fact, one would need to do a good bit of work to make it work like this....make an unbound control for initial data entry and then use a 'save' button to re-write it to the actual control....but it is all a facade....

2. repeating entries: you need to modify the query of the combo box to be 'unique values'.

2.5 using a separate standalone table/list for combo lookup makes sense for static data - i.e. the 50 state abbreviations. but for lookup of current data i.e. WorkOrders then it doesn't make sense as that data is being constantly updated...so the correct approach depends.

Be sure you have an Access textbook easily found at Amazon or any big book store. Forums are great - but reading the book helps ties together alot of things.

Hope this helps.

[weapon3000]

Thank you for the help.

I will try to get a textbook asap

[RuralGuy]

PMFJI but a "Save" button can be implimented by using a public boolean variable in the form such as blnSaveOK and setting it to True with the "Save" button. Then in the FORM's BeforeUpdate event, check the flag and execute Me.UnDo if the blnSaveOK is not True. Simple and direct and no unbound controls involved.

[weapon3000]

really helpful, thank you.

[RuralGuy]

Any time. Is this thread ready for you to use the Thread tool mark it Solved?