unbounded form

[Khalil Handal]

Hi to all,
I have a bounded form that show a selected record (single view). The form is based on a query with calculated fields. This form has a command button.
What I want is when the user press the command button, an unbounded form will open and some fields to be copied to that new unbound form.

How can this be done

Khalil

[ranman256]

its so much more work to use an unbound form with data.
why not just bind the query to the form and no more effort needed?

otherwise you must program every field to get pasted into every text box. A bound form does all this for you.

[Gicu]

In the OnOpen event of the new form you can use:
Me.txtControl1=Forms!frmFirstUnboundForm!txtContro l1
Me.txtControl2=Forms!frmFirstUnboundForm!txtContro l2
.......
Cheers,

[Khalil Handal]

Hi again,
Thank you for the reply.

What I am doing is the following:
I have two tables: table1 and table2; I select a specific record from table1 (a certain item) copy the data to a new for. On the new form I will have a combo box that allowes me to select specific record (a persons name) from table2. than I have to add more fields to the data and store the result in a query. The query represents a many-to-many relation ship (3 tables involves).

I am now in stage one were i want to copy the fields from the table1. Then I need to select the name from a combo box on the new form with source from table2, fill the necessary fields and then save the record
I was not able to do this in bounded forms.
Khalil

[Gicu]

So do you think the solution I gave you would work?

Cheers,

[Khalil Handal]

Yes Gicu
I already did it.
Now I want to add the values in that form to the query after filling the rest of the fields with the required data

[Gicu]

So what have you tried? If your form is unbound you will need to use recordset.AddNew to add to the table/query. Is your 3-table query updatable? You might need to add the data to the individual tables instead, keeping in mind that you need to probably retrieve the newly created primary key (if using autonumbers) to use in the foreign key field of the next table.

If you want to you upload a small sample of your db so we could have a look.

Cheers,

[Khalil Handal]

Hi Gicu,

I need to add data to one table only I will be using the following code: (a command button)

Dim strSQL As String
strSQL = "INSERT INTO tblBorrowedBooks (DateBorrowed, fkBookId, fkMemberId)"
strSQL = strSQL & " VALUES (' " & Me.txtDateBorrowed.Value & " ', ' " & Me.txtfkBookId.Value & " ', ' " & Me.cboMember.Value & " ') "


I am missing the use of "recordset.AddNew " procedure. How to do it?

Thanks

[Gicu]

Here you are: https://docs.microsoft.com/en-us/off...new-method-dao