Klatuu continue combine from 16th

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a field titled Reference # in 2 tables. I use 1 table to update the
other table. In the form I have a control source that is =Format([Date
Processed],"mmddyy") & [Table Letter]
What I need is the control source that was created using the format..... to
be put into the Reference # field in my table [Update Table]. I am not sure
if you can state Reference # = ...... or what.
I created the form from the [update table] and the control works to put the
reference # how I want it in the form and now I need it to carry over to the
[update table] so when I run my update query it updates the reference # field
in the [master table]
 
Patrick,
Can you restate your question a bit more explicitly?
I am getting lost as to which table is which and what [Table Letter] referrs
to.
 
I have a table called update table and a table called fruit inventory. I
have a form for the person to enter the data into that was created from the
update table. When the user enters the "bin/lot#", "date processed", "table
letter" I need the "reference#" to state =Format([Date Processed],"mmddyy") &
[Table Letter], which works in the form. What I need is for the created
reference# to show up in the update table field "reference#". Let me know if
this helps out at all. I have an update query to update the fruit inventory
table from the update table and if I can get the reference# to show up in the
update table I know it will carry over to the fruit inventory table with the
update query.

Klatuu said:
Patrick,
Can you restate your question a bit more explicitly?
I am getting lost as to which table is which and what [Table Letter] referrs
to.
--
Dave Hargis, Microsoft Access MVP


Patrick said:
I have a field titled Reference # in 2 tables. I use 1 table to update the
other table. In the form I have a control source that is =Format([Date
Processed],"mmddyy") & [Table Letter]
What I need is the control source that was created using the format..... to
be put into the Reference # field in my table [Update Table]. I am not sure
if you can state Reference # = ...... or what.
I created the form from the [update table] and the control works to put the
reference # how I want it in the form and now I need it to carry over to the
[update table] so when I run my update query it updates the reference # field
in the [master table]
Click to expand...
Click to expand...
 
You need a field in the Update table to store the reference number and you
need a control on the form bound to the referece number field in the update
table.

Then at some point, you need to populate the control with the reference
number.
You might try writing a small private sub in your module and calling it from
the After Update events of the processing date and the table letter fields:

Private sub PopRefNum()
If Not IsNull(Me.txtProcessedDate) And Not IsNull(Me.txtTableLetter) Then
Me.txtRefNo = Format(Me.txtProcessedDAte,"mmddyy") & Me.txtTableLetter
End If
End Sub

Also, you may want to check in the Form's Before Insert event to be sure
there is a value there in case the user did not complete the record.
--
Dave Hargis, Microsoft Access MVP


Patrick said:
I have a table called update table and a table called fruit inventory. I
have a form for the person to enter the data into that was created from the
update table. When the user enters the "bin/lot#", "date processed", "table
letter" I need the "reference#" to state =Format([Date Processed],"mmddyy") &
[Table Letter], which works in the form. What I need is for the created
reference# to show up in the update table field "reference#". Let me know if
this helps out at all. I have an update query to update the fruit inventory
table from the update table and if I can get the reference# to show up in the
update table I know it will carry over to the fruit inventory table with the
update query.

Klatuu said:
Patrick,
Can you restate your question a bit more explicitly?
I am getting lost as to which table is which and what [Table Letter] referrs
to.
--
Dave Hargis, Microsoft Access MVP


Patrick said:
I have a field titled Reference # in 2 tables. I use 1 table to update the
other table. In the form I have a control source that is =Format([Date
Processed],"mmddyy") & [Table Letter]
What I need is the control source that was created using the format..... to
be put into the Reference # field in my table [Update Table]. I am not sure
if you can state Reference # = ...... or what.
I created the form from the [update table] and the control works to put the
reference # how I want it in the form and now I need it to carry over to the
[update table] so when I run my update query it updates the reference # field
in the [master table]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top