choice button_problem

[Joanna_gr]

Hi! I have a little form problem and hope u can help me.
I have two linked tables from a database. One table has 7 fields (name - address - city - phone n. etc). The other table is a flag table and has only 2 fields (subscriptionID - subscription status) with only 3 choices.
subscriptionID subscription status
1 ....................... prossecced
2 ....................... rejected
3 ....................... in progress
There is a join between the 2 tables (subscriptionID)
Now the question. I created a form using all the fields from the first table. Now i want to create a choice button to identify if the subscription is prossecced, rejected or in progress. My problem is that when i choose the 1 choice for instance prossecced all the other subscriptions changed to prossecced. What may i do in this case? Hope u can help me. I have to say that both tables are linked from a database that exists in our company's network.

Regards
Joanna gr

 

[eschaef2]

Hi Joanna,

I would like to help you with your request; I have had to perform this sort of task a few times myself.

My first question is how are the two tables linked together? You imply that each customer may have a subsrciption that is in one of three states (Proceed, In-Progress, or Rejected).

How / where is the SubscriptionID in the customer table?

If it is not, you must make a field for storing the SubscriptionID for each customer....

Please let me know what else I can do to help.

Best regards,
Eric Schaeffer

 

[AlanS]

One way to do this is to use the option group wizard to build the option group (a rectangle with several option buttons). You would specify "processed", "rejected" and "in progress" as the choices, with 1, 2 and 3 as their corresponding values, and indicate that the choice should be stored in the appropriate field in your first table.

A more flexible way to do this would be to use a combo box instead. The combo box wizard will let you specify a table as the source of the combo box items, which fields to display, which column is bound to the first table, and which field it is to be stored in. The advantage of a combo box is that if additional statuses are added to the second table, you won't have to re-work the form to accommodate them.

 

[Joanna_gr]

Hi Joanna,

I would like to help you with your request; I have had to perform this sort of task a few times myself.

My first question is how are the two tables linked together? You imply that each customer may have a subsrciption that is in one of three states (Proceed, In-Progress, or Rejected).

How / where is the SubscriptionID in the customer table?

If it is not, you must make a field for storing the SubscriptionID for each customer....

Please let me know what else I can do to help.

Best regards,
Eric Schaeffer

Thans for ur reply eric. Well the 2 talbes link together with the field subscriptionID. I already created a combo box but whenever i choose i.e. proceed, it changes all the other values to proceed. My problem is that i want to change only the value for the specific customer.

Am I missing anything?

 

[eschaef2]

Hi Joanna,

Tell me more about what you see on the screen when you try to change a subscription; are you in a table view, or have you built a form, and the combo box is on the form (with SubscriptionID as its data source)?

-I believe you can 'fix' this issue if you have access to the original tables (earlier you stated that the tables are linked within your company's database).

let me know,
Eric Schaeffer

 

[Joanna_gr]

Hi Joanna,

Tell me more about what you see on the screen when you try to change a subscription; are you in a table view, or have you built a form, and the combo box is on the form (with SubscriptionID as its data source)?

-I believe you can 'fix' this issue if you have access to the original tables (earlier you stated that the tables are linked within your company's database).

let me know,
Eric Schaeffer

I'm building a FORM. my combo box is on the form (the subscriptionID is the linked field but my data source is the field "subscruption status")

Unfortunately i don't have access to the original tables but if i have a suggestion i can ask those who have access.

Thanks again
Joanna

 

[eschaef2]

Hi again Joanna,

It seems to me that you have two tables- tbl_Customers and tbl_Subscriptions that you want to use together.

Open tbl_Customers in Design view (you most likely will get a message that you can not modify a linked table. Press 'OK') and check the 'LookUp' properties for the Subscription field.

Verify the following:
Display Control: Combo Box
Row Source Type: Table / Query
Row Source: is an SQL statement that selects the SubscriptionID and Subscription description from tbl_Subscriptions
Bound Column: 1
Column Count: 2
Coulmn Heads: No
Coulmn Widths: 0"; 2" Note: 0" 'hides' the bound colum so that a user only 'sees' the second column (Proceed, In-Progress, Reject)
List Rows: 8
List Width: Auto
Limit to List: Yes

Let me know if these properties are present in tbl_Customers for the Subscription field...

We'll continue troubleshooting from there.

Best regards,
Eric Schaeffer

 

[Joanna_gr]

Eric hi again! Thanks for still being with me!

Well the combo box properties are exaclty as u described. The problem is that i a change the selection for a certain customer it changes the values for all other imports and all the imports seems to be only i.e. rejected or accepted for all the customers. Why is that?
Still

 

[eschaef2]

Hi again!

I must admit I am confused to what your expectations are compared to what the database is doing. I would like you to try another 'experiment' if you could.

Open tbl_Customers in a normal view, then enter a 'test case'. When you get to the Subscription field, does the combo box work? (do you get to choose from Proceed, In-Progress, Reject).

If you can select one of these states, and then save the record, then the issue is most likely with the combo box on the form; if you can not properly select a state within the table itself, the table relations (or design structure) will be the issue...

Let me know,

Eric Schaeffer

 

[Joanna_gr]

There is not a combo box in the table. I built one in my form and this is what i have to use! People who will use my form are not allowed to enter values directly in the tables.

So any ideas?

 

[eschaef2]

Joanna,

I have built a small mdb that I believe will do what you want it to. Please UnZip it and open frm_Trial1, then e-mail me directly with your observation(s).

I believe we can solve this dilemma with the information you just provided!

(don't give up; it's alright to be a little frustrated, but a solution can be found!)

Best regards, and I look forward to hearing from you soon!

-Eric Schaeffer

 

[Joanna_gr]

Thank you - Thank you very much

It seems that the problem was that i was trying to work on a query and not on the tables directly!

Thanks for your help! Your test form was a kind of enlightnement
Thanks afain!