Retaining 1 record within multiple forms

[Ellie.Cullen]

Hi all,

Wondered if anyone is able to help......I have 2 inputting forms. Form 1 the user inputs initial record details which allocates them with a unique number. The user submits this information which takes them to a 2nd form where they input further details in relation to the same record and the initial details are displayed at the top of the form.

At the moment the forms are linked by a 'select last record' query but I want the user to be able to find their record and edit at a later date - is this possible?

Also, when the second form has been populated the user can preview a report detailing all of the information but again, this is done via 'select last record' query - can the report be selected in relation to the respective record which may not necessarily be the last ??

Any help is much appreciated!

Ellie

 

[ajetrumpet]

I am assuming you have two forms for two different tables....if you want them to be able to edit the record information later on, maybe you could insert a few lookup combos on the form and display the record based on that selection. You could vary the way you do this too on both of your forms, but still have them both display the record in question (and the fields you want to see). Then, if you want a report on just that record information being displayed, use "Me.CurrentRecord".

 

[Ellie.Cullen]

Thank you for your response!

The forms are based mainly on 1 table. The 2nd form has a subform which links into the main table (as form 1) but there are other tables which are populated. Would this make a difference?

Ellie

 

[ajetrumpet]

It sounds like you're subform's source is the main table, just like the 1st form that is used for data entry. It doesn't matter how many forms (sub or not) are linked to a certain table...if they are, that's all you need to display a record from that table. For previewing the record information, just make sure you reference the correct form (syntax) that is displaying the info. you want to have reported.

Care to provide a screenshot of the two forms??