Split forms

[sovereign]

Afternoon,

After a lot of useful help from this forum I am back for some more!



I have a split form with search boxes that works perfectly

when the user searches it has let's say 10 results these all show in the data part.

when they click 'ok' it transfers the data into another form perfectly.

Except it always transfers the top record not the selected record.

I assume I need to put into the code to filter the query by this record and then pull the data but any help would be appreciated.

I was going to post some code but its quite a long sub due to having many routes to this stage.

Thank you so much for your help in advanced

[June7]

Why transfer data to another form?

Should not have to filter records. Code should use record that has focus.

If you want to provide db for analysis, follow instructions at bottom of my post.

[sovereign]

Thanks for your quick response.

I have to copy the data as i am using it so the users can add a exsisting client to the claim record/form.

I guess i am missing that part of record that has focus in my code.

I am just starting out on working with our already built database to do some of the work inhouse so do appologise if im asking basic things.

The database is a big database with a sql back end so sending wont be possible.

[June7]

Exactly what data needs to be copied?

Why not use form/subform arrangement?

I haven't found much use for the Split form, don't really like it - it has issues.

[sovereign]

The data will be personal details such as name address phone numbers email date of birth driver license details.

The reason for using a split form was there could be multiple results for one name/postcode and i/users find it easier to view these in a sub form (list) than having to scroll through each record.

I agree. We did have it as a 'standard' form but it has the limit of having to scroll through results rather than view them all.

[June7]

Still don't understand the copy requirement.

[sovereign]

Ok, with the fact of how i handle the data once found aside, the user still needs to find that data. How would you suggest doing this? It needs to be in a datasheet type layout i.e a list rather than individual records.

[June7]

I have a subform in Datasheet view on unbound main form. The main form has UNBOUND controls used to input search criteria. Review http://www.allenbrowne.com/ser-62.html

This can be accomplished more simply with a single form set for Continuous view and data controls arranged to look like datasheet, search controls in form header.

Option is dynamic parameterized query (I never use them):

http://datapigtechnologies.com/flash...tomfilter.html

[sovereign]

Thanks for your advice i will look into it tomorrow