answering my own question;
write the left side data to a temp table - then make query on this and right
side data......results in an updateable query...allowing a continuous form....

Signature
NTC
> User would like a spread sheet type look (former excel junkie)…but for a
> good reason. Will describe in nontechnical terms:
[quoted text clipped - 12 lines]
> forth between access & excel……presuming someone else out there has wrestled
> with the same situation would welcome ideas…..
Peter Hibbs - 05 Mar 2008 09:38 GMT
Using a Flex Grid control would be more elegant and also looks more
like a spreadsheet. Have a look at :-
http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='Flex%20Grid%20D
emo.mdb'
for some examples.
HTH
Peter Hibbs.
>answering my own question;
>
>write the left side data to a temp table - then make query on this and right
>side data......results in an updateable query...allowing a continuous form....
NetworkTrade - 05 Mar 2008 16:46 GMT
thanks will check it out

Signature
NTC
> Using a Flex Grid control would be more elegant and also looks more
> like a spreadsheet. Have a look at :-
[quoted text clipped - 9 lines]
> >write the left side data to a temp table - then make query on this and right
> >side data......results in an updateable query...allowing a continuous form....