Weird but Intresting Datagrid Question - - Urgent

[raj]

Hi Everybody;
i was just wondering if there is any way to do this:
I'm using a true DB Grid and connecting it to Access database. Is there any way i can save the whole grid(all the records in the grid)as one record in other different access database???? :confused:
details:
there's a form that contains other txtbox fields and a DBGrid. so i wanna save all the fields in access database
along with all the records in DB Grid...relating to same
record on form....so whenever i find that record on the form, it should display those records in datagrid which were entered along with those txtbox fields

If anyone has any idea how to do this...
please let me know...thanx a lot in advance
Cheers:)
Raj

[Dr_Evil]

Raj, I'm not sure I understand exactly what you are trying to do so correct me if I'm wrong.
1. You have a form that will contain info in DBGrid & txtBoxes.
2.When a record is entered or found in a txtBox you want the corresponding info to fill the db grid.
If this is right you would be better setting up a relational access database and using a SQL parameter query to find the matching records. ex( you enter info in txtBox(this would be your parameter), then use a command button on your form or use vbKeyReturn to run the query. This would fill the DBGrid with any records that matched your parameter.
If you need code or if I am not following your question correctly, post again with more info & I'll see what I can do.

[raj]

actuallly its not like that....
DBGrid is bound to different table and i'm adding records in that. Now that grid can contain many records.....
but on the other hand the form only contains one record
so what i want is when after saving the record along with DBGrid records in databse.then searching that record again n it should display those records in datagrid related to that perticular record....could be 1 , 2....any
thats what i need...if urstill not clear, please let me know...hope this explains....thanx a lot for time....
Cheers:)
Raj