Primary Key

[KirstenII]

I am still having problems with my primary key.

I am using "Unit Number" as my primary key in my main form. I would like to use a command button on this main form to go to the related record in another form in order to enter and view data. It seems as though I have the link established, however when I try to save records in the second form, it claims that I have a null value in the primary key (Unit Number).

Would this be something that's caused by an incorrect relationship??? How could I correct this (or even find out where the problem is)???

Thanks in advance for any advice or ideas.

 

[BarkerD]

When you are creating the new record on the second form, Access does not know what Unit Number to use. In a sub-form with links established, it uses the value from the main form.

Here is what I would do. On the Command button, send the Unit Number on the form open call.

Dim strOpenArgs as String
strOpenArgs=Me.UnitNumber

Docmd.OpenForm "FormName",,,,,strOpenArgs

On the second form Load Event add.

If Isnull(Me.OpenArgs)= True Then
'Do Nothing
Else
Dim strUnitNumber as String
strUnitNumber=me.OpenArgs.

'You may need to do some conversion if Unit Number is an Integer
If IsNumeric(strUnitNumber)= True then
Me.UnitNumber.DefaultValue=CInt(strUnitNumber)
End If

End If

Duane Barker

 

[KirstenII]

Been away for awhile but finally got a chance to try your advice. It worked well; thanks again for your help!!!