Re: Sub form not displaying as continuous

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

>> FatherBob wrote:
>> >I came across a problem that I have set the sub form to addnew and continuous
>> >form, however when entering data in the subform and reaching the last field
>> >the next tab takes me to the beginning of the line I just typed ( I checked
>> >the sub record and it gets written). I really want to get a new line and be
>> >able to see all the records entered in continuous form mode. Any insights
>> >would be greatly appreciated.
>>
>>
>"Marshall Barton" wrote:
>> The Tab key is just cycling to the next (in this case a new)
>> record. It sounds like you have the subform's DataEntry
>> property set to Yes.
>>
>>
FatherBob wrote:
>Marsh thanks for the suggestion but I have tried it with data entry =True and data entry = False and no difference at all. I wondered if the form had been corrupted - so I built a new one - same thing. I am probably making some fundamental error - but I don't know what it is - nature of the beast. Is it at all possible that it is a data related problem - I looked at the tables and noticed that the Ordersub was not keyed on Invoice number (which is the primary key of the Order master) does this matter? is it worth changing the table and rebuilding the forms? Or am I kidding myself?


If the subform's DataEntry property is set to Yes, then,
like John, I would suspect the LinkMaster/Child properties
are set inappropriately. The Link Master property should be
set to the main form text box bound to the OrderMaster table
primary key field. The Link Child property needs to be set
to the OrderSub table's order id foreign key.

--
Marsh
MVP [MS Access]
.