Replies

Sorry about the delay in replying, I was away on vacation. The tips at the Novell site worked.
Many thanks

Many thanks for your prompt response. I have tried the utility suggested but it does not clear the Novell WIN2000/NT log-on screen.

Many thanks – its just what I wanted and it works.

Many thanks – it works.
In my query, in the criteria box I have entered the following [Which Post Code?] and the user enters in caps alphanumeric characters like ‘SE1 5JX’ – How can I format the box so that the user needs only enter the first three characters ? Thanks

It worked ! Many thanks
Maurice

Many thanks for your time and effort in putting together the sample database to illustrate the code you suggested using. However, everything works fine on the data you have entered but when I enter a new record in the form (in your sample database) it does not update the UserRecNo field and if I run the query I get the message

Yes
Regards
Maurice Hutton

Thank you for your tips. I have tried both with no luck !
The update query gives me the following error message “Data type mismatch in criteria expression” (REC_NO is number field and REC_ID is autonumber field)
I did as you suggested in the form with the following code:
Private Sub REC_NO_BeforeUpdate(Cancel As Integer)
If IsNull ( [REC_NO] ) Then
[Forms] ! [citywest]![REC_NO] = [Forms] ! [citywest] ! [REC_ID]
End If
End Sub

It does not appear to do anything.

Any other suggestions would be appreciated.
Maurice Hutton

The data was imported from a dbf file supplied by a marketing bureau and contained the field REC_NO in which the contents were a unique number but not in any numeric sequence. I created a primary field (autonumber) called REC_ID and added several tables and linked them all via this primary filed. Everything works fine until the user adds a new record and then data in some of the forms do not display though they are in the main table.
Hope this all amkes sense.
Thanks for your prompt repsonse

The data was imported from a dbf file supplies by a marketing bureau and contained the field REC_NO in which the contents were a unique number but not in any numeric sequence. I created a primary field (autonumber) called REC_ID and added several tables and linked them all via this primary filed. Everything works fine until the user adds a new record and then data in some of the forms do not display though they are in the main table.
Hope this all amkes sense.
Thanks for your prompt repsonse
Maurice Hutton

Thank you for your patience. I think it does, I shall try it and let you know how I get on !

Thank you for your suggestion. I am not sure I follow what you mean – could you elaborate please. Sorry to be such a pain, but I am only a novice !!!!

Thanks for your response. No- as I have added other fields to the table.