forms!.... .value problem

c19h28O2

Registered User.
Local time
Today, 00:54
Joined
Jan 23, 2007
Messages
12
Hi,

most of this code works fine...

Code:
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
 
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
 
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
 
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?
 

Users who are viewing this thread

Back
Top Bottom