Urgent ! Please !

[nebon]

Please guys, bare with me please.
I have this problem, I can not come up with a solution.
The thing is, I have a form called booking : in there I have 2 comboboxes . and both of them unbound. To add records to the form works perfect. But when I try to edit a record the comboboxes would be blank since they are unbound, and the question is, how can I change the comboboxes value in accordance to the selection of the record.
I tried to change the comboboxes controlsource (using the bound column) but this would only create more problems, this would give me errors when I try to add/modify a record, but they would change in accordance of the selection of the record.
any ideas how I can fix this , thank you very much for your time!

 

[crosmill]

I would assume the combo boxes need to be bound to a field on the underlying table unless your trying to do something different with them.

what do the combo boxes do?

 

[pdx_man]

So then, you have two unbound combo boxes that are used to populate the current record. I'm guessing there is a bound control, then, that is assigned the value from the combo box. Let's call that bound control MyTextBox. For the control source of the associated combo box, try:

=[MyTextBox]

Then, when you change records, the combo box will display the value in the associated text box.

 

[nebon]

hallo , and thanks alot for the help, but I am still not getting anyway , this is annoying ... I have been on the same issue 2 days .... someone please rescue me and take a look at the database ... please ...

access 2000:
www.chuchu.plus.com\db2k.zip


access 97:
www.chuchu.plus.com\db97.zip


Run the FrmBooking, and try to add or change the record and see what happens .......... ! ;(

 

[crosmill]

bad links

 

[nebon]

Please try again , they are definitely up on the server ... tried on my IE and it worked!

 

[crosmill]

Your right, you need IE, I use mozilla by default.

I can't get it to work, both the find and add buttons just error.

Also the table appears to be based on SQL, why not just build a query and base it on that, it'll be a lot easier to manage.

 

[nebon]

hallo again , well, the find works at some point you can go to the record you are selecting, but as soon you try to modify it it wont work, thats my problem mate, any ideas how I can fix this ?
and what do you mean, the tables are done in sql do them in a query ??? a query is done in SQL, dont really know what you mean .. thanks

 

[crosmill]

Whenever I try to select a booking it chucks up the Debugger screen.........?

If you build a query and then base the form on that query. What you appear to have done is to build an unbound form and then written sql in the row source of each element. :-Time consuming......?

 

[nebon]

I have tried that as well... but same thing ... can you try to fix it ? and this is exactly what I mean , the debugger screen, it always comes up ......!! thanks ..

 

[crosmill]

Sorry mate, I'm at work I don't have time to sift through the whole thing.

 

[nebon]

okai, .. thanks anyway

 

[nebon]

someone else ?

 

[pdx_man]

Sometimes we tend to make things out to be more difficult than they actually are. The Recordsource for the form was trying to do too much. Simplify. Try to ascertain what you need to do and just stick to that. I made a lot of changes to the recordsource, created a query, changed the data type for the PK for the Bookings table and added some functionality to the Members TB.

HTH

(Had to strip down the DB to post here)

 

[nebon]

Hallo man ...
thanks alot , a bunch of thanks , everything is working, but man , isnt it possible to do that with the comboboxes instead of having 2 extra textboxes ? thanks anyway, and if possibe why did I always get the debuging error when I tried (before you fixed it) .. thanks again

 

[Pat Hartman]

It appears that I wasted my time thinking about your problem in one of your duplicate threads. In the future, please stick to a single thread rather than creating multiples that just waste people's time.