Form

[Sed]

Somebody help!!! I working in form and I want my form to choose from a query on a specific field.

 

[pbaldy]

Welcome to the site. Please keep in mind that you have your database in front of you, and you know exactly what you want to accomplish. We're looking at a blank piece of paper. You need to give enough detail so we understand what you're trying to accomplish. Based on what you've written, I can't tell.

 

[georgedwilkinson]

See my siggy. (And Paul's tag line)

 

[missinglinq]

As I tell posters on the forum I moderate, "Carnac the Magnificent no longer comes to this forum!"

But at a guess, the OP might go into the code editor and use Help to look up DLookup.

 

[Sed]

Sorry Pbaldy, this is my first time in the form. I'm not even sure I get a reply. Anyway, here it is.

In my query I have a formula that that ref. to 2 tables. One table has 19 root causes and 2nd one has one less. the formula is like this RootCauses: IIF((Shipments.Lead_Time+Shipments.Order_Date>Shipments.Due_Date),Issues2.Issue,Issues.Issue)



Currently in my form, when I right click on my root causes and go to the property, the row source is this: SELECT Issues.Issue_ID, Issues.Issue FROM Issues ORDER BY [Issue];

What I want is the rootcause combo box to reference to either my tables or the formula field in my main qeury.

The big picture is that, If the Lead time + the order date is > than the due date, then I dont want the person to see Late Shipment, else I want them to see all the root causes.

many thanks...I've been breaking my head over this for 3 days.

P.S. Since this is my first time in the forum. Please let me know what I can do to help this site or you with the help. I understand that not is free.

 

[pbaldy]

For starters, you don't need to do anything for me or the site. The forum is truly free. We who answer questions do so because we enjoy it, and we expect nothing in return.

Can you post a sample db?

 

[Sed]

Good to know. thanks.. I'm very new at this. How do I post my DB. I'm happy to email it to you. if you want. You can also call me.

 

[pbaldy]

http://www.access-programmers.co.uk/forums/showthread.php?t=140587

 

[Sed]

Here you go. thanks a bunch. If you happen to be in Atlanta any time soon let me know, dinner is on me.

 

[Sed]

Pbaldy,

the name of the form is "Main Form Expedites" and it's from "qry Planner form"

 

[Sed]

Just in case I didn't do it right the first time

 

[pbaldy]

Houston, we have a problem. The attachment didn't make it.

 

[Sed]

it should be there now

 

[Sed]

Pbaldy,

Please let me know if you are able to see my posted Db.

 

[Sed]

Pbaldy,

the compressed file is 2.21M. everytime I tried to upload, it failed. Is there any other means to get this in your hands?

 

[pbaldy]

You can send to

deleted to prevent spam

 

[pbaldy]

What is the purpose of the two different issue tables? I would expect one. Also, I don't see a combo called Root Cause on that form (or anything resembling it). It should be noted that much wine was consumed last night, along with yummy bagna calda. My eyes/brain might not be up to speed yet!

 

[missinglinq]

Well, eating anything with anchovy paste in it would require consuming large quantities of the grape, wouldn't it?

 

[pbaldy]

It would! Actually, perhaps because there's so much garlic, you can't even taste the anchovy, which I don't normally care for.

 

[Sed]

What's bagna Calda?
One Issue table has all the issue category and Issue2 does not have "supplier - Late Shipments" as one of the category