No entry on open form

[grant.smalley]

Hi,

I have a main form (called MainFrm) and a tabular subform (called NotesFrm) that contains notes. The two forms and tables are linked by a Primary Key called FraudRef.

I want users to create a new note in the subform using a seperate pop up box. To acheive this, i need the form to open as a new record but still link to the main form by the Primary Key.

Any ideas?

Regards,



Grant

[maximus]

Well as far as i can understand that you need to open a blank subform so that the user can enter data.

Solution:

open the NotesFrm in the design view. Click on form properties. Go to Data and in the catagory Data Entry select Yes. This will always open the subform to record new data. If this solves your problem please mark this thread as solved.

[grant.smalley]

I made a mistake in my earlier post. The form is a seperate form not a subform. If i select the catagory Data Entry as Yes then the Primary key in the form is set as o.

Any thoughts?

[maximus]

Now tell me do you want to do. Do you require to populate the primary key field with a certain value when you open the form.
here are some information that i will require to help you out:
1. Do you open this form through another form.
2. Do you have the condition field in the form from which you open this form.

why don't you zip your database and attach it so that i can help.

[grant.smalley]

Hi,

I've worked it out now. Ive added the following in the on current event on the form:

Private Sub Form_Current()
Me.[Fraud Ref] = Forms!NewMainFrm![Fraud Ref]
End Sub

This populates the primary key from the main form to the notes form and i have set the notes form to data entry.

Thanks any.

P.S. Do you have any idea how to resolve my other post:

https://www.accessforums.net/forms/a...text-3929.html

Many thanks

Grant