Different default values for different forms

[pshoestir]

I am trying to create an access form that will automatically default one of the bound table fields to a specific value. Basically here is a simplified explanation of the setup; I have a "Purchase Order" table that is bound to the form. One of the fields in the Purchase Order table is a combo box linked to another table called "Plant Location". Currently there are only two items in the Plant Location table, a FL and a GA. I am going to create two forms, a "FL Purchase Order" and a "GA Purchase Order" one. What I need help with is figuring out how to have the FL Purchase Order form default the Plant Location to FL and have the GA Purchase Order form default the Plant Location to GA. Could someone please offer advice on how to accomplish this.



Thanks in advance,

PS

[pbaldy]

Why have different forms, rather than a single form where you chose the location? I'd say the same thing about tables, if you have separate tables for them.

[pshoestir]

I am having all of the Purchase Orders go to the same table, both FL and GA. There are several reasons for doing this, mainly because of who my end users are.

[ranman256]

I have a table, tConfig. I set my defaults here, so when the person gets it , the app reads this 1st.

For you, you can do this , or set the combo for FL for 1 group before you send it to them,
set the other to GA before sending theirs.

[pshoestir]

Isn't there some VBA code to force the value that I want?

[pbaldy]

I am having all of the Purchase Orders go to the same table, both FL and GA. There are several reasons for doing this, mainly because of who my end users are.

You may have misunderstood, as that's what I would recommend: a single table with a field for location. I'd have a single form, and set the value in some way appropriate to your app. For instance if they clicked on a "FL" button, I'd open the form and then set the value:

DoCmd.OpenForm "FormName"
Forms!FormName.TextboxName = "FL"

[pshoestir]

Let me give that a whirl and see how it goes. Thanks for the help!

[pbaldy]

No problem, post back if you get stuck.