Forms and Combo Box

[Sed]

Please help!!! I've been working on this forms for 3 weeks now and I think I'm going crazy!!!

In my Access form I have a field that gives me, Lead_Time, Order_Date and Due_Date. I also have a combo box that listed all my root causes.

What I want to do is...when they enter the Shipments.Lead_Time+Shipments.Order_Date>Shipments.Due_Date, then omit "Supplier - Late Shipment" else give me all my option.

Is this possible?

 

[RuralGuy]

What control has "Supplier - Late Shipment" as an option. If it is the ComboBox you mentioned then what is the RowSource for the control?

 

[Sed]

I'm not sure if I understand your question, but the row source is from a table. ROW SOURCE: SELECT Issues.Issue_ID, Issues.Issue, Issues.Issue2 FROM Issues ORDER BY Issues.Issue; The first table has all the "issues" categories and the "Issues2" has all except the "supplier - late shipment"

 

[RuralGuy]

I'm not sure if I understand your question, but the row source is from a table. ROW SOURCE: SELECT Issues.Issue_ID, Issues.Issue, Issues.Issue2 FROM Issues ORDER BY Issues.Issue; The first table has all the "issues" categories and the "Issues2" has all except the "supplier - late shipment"

Even though you say "the first table" it looks like you only have one table with at least three fields. Do I understand this correctly?

 

[Sed]

yes that's correct. Right now I have 3 field. Issue_ID, Issue and Issue2

 

[RuralGuy]

Why do you have the two Issues fields?

 

[Sed]

I don't know!!! I thought I have one with all the root causes and one with the one I want to omit. I was testing stuff out.

 

[Sed]

Can I send you my db and we can go through it?

 

[RuralGuy]

I'm not sure what you mean by "root cause" but you can use a filtered RowSource on the ComboBox if your conditions are met. It sounds like you only need the two fields in the issues table: IssueID and Issue. Make two queries of the Issues table and have one criteria for the Issue field as Not "supplier - late shipment" or whatever you do not want. Check the Datasheet view of this query to see of it works as you want and then switch the RowSource of the ComboBox when your condition is met.

 

[RuralGuy]

Can I send you my db and we can go through it?

If you Compact and Repair and then ZIP it, is it < 786KB?

 

[Sed]

Yes, it's too big to post it.

 

[Sed]

I can send it via email.

 

[RuralGuy]

Go ahead and send it.

 

[Sed]

What's your email?

 

[Sed]

Did you get my DB?

 

[RuralGuy]

Twice! I got another one this morning. Why two? I made some changes to the 1st one and sent it back to you last night. Did you get it?

 

[Sed]

Sorry, I got a returned mail and I thought the first one didn't go through.

And, No I did not get the one you send back

 

[RuralGuy]

Look in the Current Event of the FORM and the AfterUpdate event of the controls involved in the calculation for how it was accomplished.

 

[Sed]

I'm a little lost, How do I get to the "current event" and the "afterUpdate event" of the form and the

 

[Sed]

I'm in Design veiw and I see that you've added something in there. I'm lost.
I know you've added two queries and that's about it. Please walk me through this