If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Adding a sub form
I am trying to insert a sub form linked to a query. In the main form design
view I clicked sub-form and chose 'Use an existing form' in the wizard, selected the form I wanted, chose to define my own fields and linked EnvelopeNumber in the main form to EnvelopeNumber in the sub form. When I try to open the form I get a message 'You tried to lock the table while opening it, but the table cannot be locked because it is currently in use. Wait a moment and try the operation again.' When I click again I get a blank white space where the sub form should be. The same thing happens if I choose the sub form in the wizard and then just click 'finish'. Can anyone tell me what I am doing wrong? Thanks Dudley |
#2
|
|||
|
|||
Adding a sub form
When I try to open the form I get a message 'You tried to lock the table
while opening it, but the table cannot be locked because it is currently in use. Wait a moment and try the operation again.' When I click again I get a blank white space where the sub form should be. The same thing happens if I choose the sub form in the wizard and then just click 'finish'. Can anyone tell me what I am doing wrong? The subform isn't by any chance based on a query that uses the same table that the main form is based on is it? Tom Lake |
#3
|
|||
|
|||
Adding a sub form
Yes it is. If this is not allowed how do I get round the problem? Do I need
to create a query with all the fields I need rather than use a sub form? Thanks for your help. Dudley "Tom Lake" wrote: When I try to open the form I get a message 'You tried to lock the table while opening it, but the table cannot be locked because it is currently in use. Wait a moment and try the operation again.' When I click again I get a blank white space where the sub form should be. The same thing happens if I choose the sub form in the wizard and then just click 'finish'. Can anyone tell me what I am doing wrong? The subform isn't by any chance based on a query that uses the same table that the main form is based on is it? Tom Lake |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Controls disappear from Data Entry form | Paul Ponzelli | Using Forms | 10 | February 26th, 2006 05:51 AM |
Date range on reports | Mark_Milly | Setting Up & Running Reports | 10 | January 19th, 2006 03:49 PM |
Move feild entries from form to form using global variables | JackCGW | General Discussion | 11 | November 14th, 2005 05:22 AM |
Requerying a pop up form to display in the main form | Jennifer P | Using Forms | 13 | April 5th, 2005 06:59 PM |
dlookup | miaplacidus | Using Forms | 9 | August 5th, 2004 09:16 PM |