optron
Posts: 114
|
| Posted: 10/24/2006, 7:27 PM |
|
I'm passing parameter from Record to Grid, however despite I see the parameter passed in the browser's address line the edit form can't pick it up, and opens up blank.
Can someone give me a hint please what I might be doing wrong ?
Do I have to use primary key only for the table in order for this to work or is any indexed column OK ?
(ASP+Access)
Arthur
_________________
==============================
don't forget to check: www.youngliving.us
use: 739947 to register |
 |
 |
Edd
Posts: 547
|
| Posted: 10/24/2006, 9:02 PM |
|
The form will populate default values on an add (if that is what you want to do).
To do this, in designer, go to the address line and in the default value type
CCGetFromGet("NameOfMyPassedParameter", "")
Edd
_________________
Accepting and instigating change are life's challenges.
http://www.syntech.com.au |
 |
 |
optron
|
| Posted: 10/24/2006, 11:26 PM |
|
thank for repy, but this isn't a case. I simply want to populate proper
record values on CHANGE. I have several grid pages with apropriate edit form
assigned for them. Amazingly some of them work fine and when I get into
CHANGE(edit) mode they populate fields with existing data, however 2 forms
don't. It looks like I did everything the same way I did for the other forms
that work, and I can't figure out why this is not working.
Edd - your tip for populatin on ADD sound also interesting, is this
mentioned anywhere in the docs ?
Arthur
"Edd" <Edd@forum.codecharge> wrote in message
news:6453ee1e45dfb6@news.codecharge.com...
> The form will populate default values on an add (if that is what you want
> to
> do).
>
> To do this, in designer, go to the address line and in the default value
> type
>
> CCGetFromGet("NameOfMyPassedParameter", "")
>
> Edd
> _________________
> Accepting and instigating change are life's challenges.
>
> http://www.syntech.com.au
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
>
|
|
|
 |
optron
|
| Posted: 10/25/2006, 12:14 AM |
|
OK, I discovered an error myself. What I haven't noticed after importing
database into Access, IMPORT function inserted spaces in field names (column
names), and this caused a problem while passing parameters. After removing
spaces it works fine, so watch for spaces in column names while
defining/importing your tables.
Arthur
"optron" <optron@sbcglobal.net> wrote in message
news:ehn02l$of4$1@news.codecharge.com...
> thank for repy, but this isn't a case. I simply want to populate proper
> record values on CHANGE. I have several grid pages with apropriate edit
> form
> assigned for them. Amazingly some of them work fine and when I get into
> CHANGE(edit) mode they populate fields with existing data, however 2 forms
> don't. It looks like I did everything the same way I did for the other
> forms
> that work, and I can't figure out why this is not working.
>
> Edd - your tip for populatin on ADD sound also interesting, is this
> mentioned anywhere in the docs ?
>
> Arthur
>
>
>
>
>
> "Edd" <Edd@forum.codecharge> wrote in message
>news:6453ee1e45dfb6@news.codecharge.com...
>> The form will populate default values on an add (if that is what you want
>> to
>> do).
>>
>> To do this, in designer, go to the address line and in the default value
>> type
>>
>> CCGetFromGet("NameOfMyPassedParameter", "")
>>
>> Edd
>> _________________
>> Accepting and instigating change are life's challenges.
>>
>> http://www.syntech.com.au
>> ---------------------------------------
>> Sent from YesSoftware forum
>> http://forums.codecharge.com/
>>
>>
>
>
>
|
|
|
 |
|