More Combo problems....

[Gentleviking]

I realized a few days ago that I have an issue with my combo box that I got help on. I am now struggling with 2 combos and 1 text box: 1. Source, 2. Operator/Agent, Text: Specify Operator/Agent.

If I first enter Operator/Agent as source, then the second combo (Operator/Agent) will be enabled and I can choose from the dropdown. If the choice is “x Other” the Text BOX will be enabled so a manual text entry can be done.

So far so good. Everything is recorded in the main table “Reservations”.

However, if I after having done the above then go back and change the Source to something else than Operator/Agent and the combo 2 and the Text Box are disabled then the previous entries in the combo 2 & Text Box still is and remain recorded in the main table.

I know that this will not happen if I delete the entries and make the fields in combo 2 & Text Box blank, but I hope there is a way to get around this! Is there? Is it possible to code something so that whatever is previously selected/written in combo 2 & Text Box is disregarded and not recorded as long as the combo 1 has any other choice selected but “Operator/Agent”?

I am curious about one other thing. As can be seen I have several text boxes that do a simple sum calculation. They are all formatted to default 0.00 and Standard. The funny thing is that when I open a new record, it is only a few of those boxes that display the default 0.00. But, as soon as I enter info anywhere on the form (even in boxes not related to them, then all suddenly display the 0.00. Can anyone tell me why?

Any assistance is greatly appreciated! Thanks a lot in advance!

PS
By the way, is there any way to disable the default menu bar at the bottom of the form?

 

[RuralGuy]

By the way, is there any way to disable the default menu bar at the bottom of the form?

Do you mean the Navigation Buttons? Look on the Format tab of the Property sheet for the form. Here's something to read while I review the rest of your db. The Evils of Lookup Fields in Tables

 

[Gentleviking]

Thank you for the tips, RuralGuy!

Is there anyone that can help me with my combo issue? Please!!!

 

[ansentry]

I gave you the first answer, the answer you are looking for this time just an extension of that.

I also agree with RG re the look up fields in tables. In your Reservations table you should only be storing the key from the the source table etc and not the text.

Anyway I have attached you db with the problem solved, maybe not the best coding but the works.

Also if I may suggest that you name you tables form etc as;
Tables - Example:
tblReservations

Queries - Example:
qrySource

Forms - Example:
frmReservations

Also in you form name text boxes as txtArrival , combo boxes as cboStatus, you will find that it help in the long run.

end of rant.

Good luck with the rest of your project.

 

[Gentleviking]

Thank you John! I know of course that you helped me the first time around, but i did not want to be bothering you by asking help from you specifically! But, you returned and made it perfect...again! Thank you so much!!!

As I have said before I am complete novice at Access as of 2 weeks ago, and everything I have done this far is by trying and failing (and getting help from you and directions from other posts), so, when you say: "In your Reservations table you should only be storing the key from the the source table etc and not the text" I see what you write, but I do not understand what to do or and how to do it :-(

If I also may ask just quickly one small thing... I have inserted the command code so that always a blank form opens when the data base is started. I used to have a requirement for f.ex. the Reservation Number field that six digits needed to be entered. However, when I got the blank start up form, and then hit the Search button I got an error message saying that the Reservation Number needs to be filled. If I clicked on the Clear button (even when the form was already clear) then the Search function would open. So, I remeved the requirement, and now the search works right away on the clear form. But, now, if I open the clear form, do nothing, and then just exit, then there is a blank row inserted in the Reservations table. What can I do? Do you understand what I mean and what my problem is?