Search results

What you are trying to do is move a record from 1 table to another. Not from one form to another. To "move" the record from your "Main" table to your "History" table, use an append query and then run a delete query to remove the record from the main table. OR You can just "flag" the record...

Here is your sample back.

Have a look at the attached sample. Examples for both single and continuous forms, one uses code and the other a query.

qulaitks, Here is your db back and working. I have created a new table, query and report. In your table you had Now() as the default for the Date Field. That mean that when a record is created it get "NOW" date, time (including seconds), so when you try use criteria of date it will only...

First, Welcome to the Forum. Have a look at the attached sample; it should do what you want. It is NOT my code and I don't know where I got it from so I can't acknowledge someone’s good work. Good Luck.

acCheckBox

Here is your db back.

I am not saying I can solve your problem, however you have explained how much trouble you are having but not what the problem is.

Have a look at the attached sample.

Put this code with the code that opens your other form. Put it before the DoCmd.OpenForm etc DoCmd.RunCommand acCmdSaveRecord Example of how it would be used; Dim stDocName As String Dim stLinkCriteria As String DoCmd.RunCommand acCmdSaveRecord stDocName = "frmProjectDetails"...

Have a look at my sample posted Here It will fill in all controls when you created a new record. Any questions post back.

rgreene, Have a look at the attached sample;

Point the the database file, right click it select properties (at the bottom) and have a look to see if Attributes have a tick in the Read Only box if so take the tick off. This can happen if you copy the file from a CD to you computer. Otherwise I don't know.

Hold down the shift key as you open the database.

bsnapool, Have a look at the attached sample, it uses Bob's code and I have added a small piece so that you can go to a new record and the "Null" message will not appear.

Statsman, If you use the method in my sample you don't need code. Maybe I'm wrong but I though that linking tables with keys was the way to go. Someone may be able to enlighten me if I am wrong.

Ross, Have a look at the attached sample, it will do what you want. Have a look in the tblData and you will see that only the key is stored for the data (fkCustomerID). Have a look at the query qryDataDetail and you will see how the foreign key link is used to turn the key back into data. You...

Here is your db

This is what I use behind a button on my Main form. You have forgotten the bit in bold. Me.sfrmVehicles.Form.txtVehicleMake.Locked = False May I suggest that you name the controls different to their Control Source. In my example that is the Name of the Control and the Control Source name is...

Have a look at the sample I posted it does what you want; >> Here <<