default data from table

[vicsaccess]

ok, I need some help researching a new idea. I have a form on a split front end that uses default values based on the location that the front end is located. currently I have the default values set in properties and in the code of each front end, but this gets tedious remembering to change all the defaults each time I give them a updated front end and I have been known to forget one or two. what I would like to look into is whether I can make a table in each front end, lets say DefaultT, with the default values for things like location, line and contacts, and have the text boxes and VBA pull from that table for its values. can someone point me in a direction of research or a sample that uses this method. i'm sure this is a common thing but as I am learning as I see needs this is new to me thank you in advance.

[vicsaccess]

currently i'm using-
Private Sub Form_Load()
Me.OrderBy = "DailyProdID DESC"
Me.OrderByOn = True
DoCmd.applyfilter,"lineid=11"
End Sub

the "11" represents the line. what I would envision is to pull my value from the table called "default" field name "lineid" which is set to 11. just not sure how to pull the value from a table and then apply it to the filter. can anyone point me in a direction?

[RuralGuy]

I'm not real sure I understand what you mean by "Default values".

[vicsaccess]

I would like to put the value of 11 in the table "defaultT" field name "lineid" and have the bound text box on my form default to what ever value I put in the table "defaultt", field name "lineid"

[RuralGuy]

You would probably need to use a DLookup to retrieve the "default" table value.

[RuralGuy]

Does that make any sense ?

[vicsaccess]

thanks RuralGuy, I used-
Private Sub btnNewShift_Click()
DoCmd.GoToRecord , , acNewRec
Me.LineID = DLookup("lineid", "defaultT")
Me.LocationID = DLookup("locationid", "defaultT")
End Sub

now what ever value I set in my default table the lineid and locationid sets as a default value, yea. can I also use the dlookup to store a email address in my default table and email a report with the sendobject command to the address that is stored there?

[RuralGuy]

DLookup is read only. If that works for you then YES.