Subform Record Count Using Textbox

[Beany]

Hi,

Can some please provide me with the code for counting records in a subform and displaying it in a textbox?

Does this code go into the control source of the textbox?

My subform is called 'Asset subform' within the form 'Form1'.. the textbox will be in the same form.


Also im showing records in a subform by selecting a user from a combobox...

How can i input a users name in a textbox once i have selected him from the combobox?


All help will be appreciated

[ADezii]

Hi,

Can some please provide me with the code for counting records in a subform and displaying it in a textbox?

Does this code go into the control source of the textbox?

My subform is called 'Asset subform' within the form 'Form1'.. the textbox will be in the same form.


Also im showing records in a subform by selecting a user from a combobox...

How can i input a users name in a textbox once i have selected him from the combobox?


All help will be appreciated

In the Control Source of the Text Box on Form1, place the following code:

=DCount("*","<Record Source for Sub-Form>","[<Linking Field>]=" & Forms!Form1![<Primary Key>])

[Beany]

In the Control Source of the Text Box on Form1, place the following code:

=DCount("*","<Record Source for Sub-Form>","[<Linking Field>]=" & Forms!Form1![<Primary Key>])

for some reason im getting an error : Error?

ive inserted the following code:

=DCount("*","<Asset subform>","[<Text16>]=" & Forms!Form1![<ID>])

Am i doing something obviously wrong?

My subform is called: Asset subform
My Form is called: Form1
TextBox is called: Text16

and the primary key for my main table is 'ID'...

im confused???

[missinglinq]

First off, drop the < and > ! When used in example code, whether here or in text books, <Things Like This> takes the place of an object name, so if your Primary Key is named ID,

[<Primary Key>]

would become

[ID]

when you actually write your code.

Linq ;0)>

[Beany]

Hi,

thanks for reply,

ive tried that, got rid of the <>

but im still getting an error??

[ADezii]

Hi,

thanks for reply,

ive tried that, got rid of the <>

but im still getting an error??

Replace Asset subform with the Name of the Record Source for the Sub-Form via Select Asset subform ==> Properties ==> Data Tab ==> Record Source.

[Beany]

Thank you for the replies..

the record source for my subform is:

SELECT Asset.ID, Asset.Asset, Asset.[Product Type], Asset.Manufacturer, Asset.Description, Asset.[Model No], Asset.[Serial No], Asset.[Windows Key], Asset.User, Asset.Department, Asset.Location, Asset.[Comms Date], Asset.Returned, Asset.[Return Reason] FROM Asset WHERE (((Asset.User) Like Forms!AssetMain!Combo2)); 

so ive got the following:

=DCount("*","SELECT Asset.ID, Asset.Asset, Asset.[Product Type], Asset.Manufacturer, Asset.Description, Asset.[Model No], Asset.[Serial No], Asset.[Windows Key], Asset.User, Asset.Department, Asset.Location, Asset.[Comms Date], Asset.Returned, Asset.[Return Reason] FROM Asset WHERE (((Asset.User) Like Forms!AssetMain!Combo2))","[Text16]=" & [Forms]![Form1]![ID])

But im still seeing an error?? y?
thanks

[ADezii]

Thank you for the replies..

the record source for my subform is:

SELECT Asset.ID, Asset.Asset, Asset.[Product Type], Asset.Manufacturer, Asset.Description, Asset.[Model No], Asset.[Serial No], Asset.[Windows Key], Asset.User, Asset.Department, Asset.Location, Asset.[Comms Date], Asset.Returned, Asset.[Return Reason] FROM Asset WHERE (((Asset.User) Like Forms!AssetMain!Combo2)); 

so ive got the following:

=DCount("*","SELECT Asset.ID, Asset.Asset, Asset.[Product Type], Asset.Manufacturer, Asset.Description, Asset.[Model No], Asset.[Serial No], Asset.[Windows Key], Asset.User, Asset.Department, Asset.Location, Asset.[Comms Date], Asset.Returned, Asset.[Return Reason] FROM Asset WHERE (((Asset.User) Like Forms!AssetMain!Combo2))","[Text16]=" & [Forms]![Form1]![ID])

But im still seeing an error?? y?
thanks

You must use a Table name or Query for the 2nd Argument for the DCount() Function as in:

DCount("*", "<Table Name>")
DCount("*", "<Query Name>")

[Beany]

You must use a Table name or Query for the 2nd Argument for the DCount() Function as in:

DCount("*", "<Table Name>")
DCount("*", "<Query Name>")

honestly im confused now, why two Dcounts?

thanks

[missinglinq]

Use one or the other !

[Beany]

excellent,

thank you for your patience...

it counts the records now.... it counts the users in the table 'Asset'.

Im selecting a user from a combobox, and then displaying the records for this user in the subform. how can i get it to count records in the subform?

[Beany]

anyone?

any help will be appreciated..

thanks