record Number and Customer Number

#1 (**permalink**) 28-Jul-2006, 08:16 AM

I have a customer file and it has a recordid as primary key autogenerate
and customer number is also generating by the DMax("[zfileno]","zfile")+1.
at one time recordid and zfileno was same but after delete of some records,
now the recordid and zfileno is different. when I am using lable print from a
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/10783-record-number-and-customer-number.html
form selected record it was printing fine when the recordid and zfileno was
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10783
same when it become diff then it is not printing the selected record as on
selection I have strWhere=[Recordid]
what is the best way to print the same record from the form.

#2 (**permalink**) 28-Jul-2006, 08:16 AM

Mohammed wrote:
> I have a customer file and it has a recordid as primary key
> autogenerate
> and customer number is also generating by the
> DMax("[zfileno]","zfile")+1. at one time recordid and zfileno was
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10783
> same but after delete of some records, now the recordid and zfileno
> is different. when I am using lable print from a form selected record
> it was printing fine when the recordid and zfileno was same when it
> become diff then it is not printing the selected record as on
> selection I have strWhere=[Recordid]
> what is the best way to print the same record from the form.

More information please. What are the relationships and table
structures?

What is the sql for the selection to print. How are you "selecting"
records to print?

--
Joseph Meehan

Dia duit
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10783

#3 (**permalink**) 28-Jul-2006, 08:16 AM

Provided you include the RecordID field in the label report's RecordSource
you can still use it to print the current record even though it differs from
the customer number. The RecordID does not need to appear on the label. The
code in the Click event procedure of a button on the form would be something
like this:

Dim strWhere As String

strWhere = "RecordID = " & Me.RecordID

' first make sure record is saved
RunCommand acCmdSaveRecord
' print the label
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10783
DoCmd.OpenReport "YourLabelReport", WhereCondition:= strWhere

You could also do it by using the customer number as this also uniquely
identifies the record, in which case you'd use something like:

strWhere = "[CustomerNumber] = " & Me.[CustomerNumber]

Ken Sheridan
Stafford, England

"Mohammed" wrote:

> I have a customer file and it has a recordid as primary key autogenerate
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=10783
> and customer number is also generating by the DMax("[zfileno]","zfile")+1.
> at one time recordid and zfileno was same but after delete of some records,
> now the recordid and zfileno is different. when I am using lable print from a
> form selected record it was printing fine when the recordid and zfileno was
> same when it become diff then it is not printing the selected record as on
> selection I have strWhere=[Recordid]
> what is the best way to print the same record from the form.
>