forms!.... .value problem

[c19h28O2]

Hi,

most of this code works fine...

SELECT Forms!FRM_UKBA_AMENDMENTS_INPUT!ACCOUNT_NUMBER.value AS Expr1, Forms!FRM_UKBA_AMENDMENTS_INPUT!SORT_CODE.value AS Expr2, Forms!FRM_UKBA_AMENDMENTS_INPUT!PRODUCT_IDENTIFIER.value AS Expr3, Forms!FRM_UKBA_AMENDMENTS_INPUT!VALUE_LINE_IDENTIFIER.value AS Expr4, Forms!FRM_UKBA_AMENDMENTS_INPUT!VALUE_LINE_AMOUNT.value AS Expr5, Forms!FRM_UKBA_AMENDMENTS_INPUT!OFFSHORE_INDICATOR.value AS Expr6, Forms!FRM_UKBA_AMENDMENTS_INPUT!UKBA_SUMMARY_DATE.value AS Expr7, Forms!FRM_UKBA_AMENDMENTS_INPUT!UKBA_AMENDED_BY.value AS Expr8, Forms!FRM_UKBA_AMENDMENTS_INPUT!UKBA_AMENDMENT_REASON.value AS Expr9, Forms!FRM_UKBA_AMENDMENTS_INPUT!UKBA_AMENDMENT_DATE.value AS Expr10;

However expression 7,9,10 do not display their values. All the textboxes on the form are the same 7 and 9 are date fields and 10 is a text field, any ideas why these would not show but the other fields do?

Thanks

Michael

 

[c19h28O2]

Guys,

the code should like this this.....

SELECT Forms!FRM_UKBA_AMENDMENTS_INPUT!ACCOUNT_NUMBER.value AS Expr1,
Forms!FRM_UKBA_AMENDMENTS_INPUT!SORT_CODE.value AS Expr2,
Forms!FRM_UKBA_AMENDMENTS_INPUT!PRODUCT_IDENTIFIER.value AS Expr3,
Forms!FRM_UKBA_AMENDMENTS_INPUT!VALUE_LINE_IDENTIFIERvalue AS Expr4,
Forms!FRM_UKBA_AMENDMENTS_INPUT!VALUE_LINE_AMOUNT.value AS Expr5,
Forms!FRM_UKBA_AMENDMENTS_INPUT!OFFSHORE_INDICATOR.value AS Expr6,
Forms!FRM_UKBA_AMENDMENTS_INPUT!SUMMARY_DATE.value AS Expr7,
Forms!FRM_UKBA_AMENDMENTS_INPUT!AMENDED_BY.value AS Expr8,
Forms!FRM_UKBA_AMENDMENTS_INPUT!AMENDMENT_REASON.value AS Expr9,
Forms!FRM_UKBA_AMENDMENTS_INPUT!AMENDMENT_DATE.value AS Expr10

 

[GaryPanic]

whats the format of the underlying table ??
10 looks like it should e a date field and not a txt field
9 looks like a txt field and not a date field

 

[c19h28O2]

Apolgoies, 9 is a text field and both 10 and 7 are date fields on the table...., i did have it working but its very very temperamental!

Any ideas?