Can any one help me in getting this values.

[SAM453]

Hi every one i need little help.

What iam doing is updating a record using front end.
So user will enter a sequence number and based on that sequence number records should display in text fields based on that sequence number.
User will now edit the records and hit the enter button so the changes will be saved in backend sql table.

I have one combobox and 5 text fields. Based on the combo value text field values should display automatically.

i can get data only in one text field not in all text fields. I need in all text fields.
What i should do???

Thanks,
SAM.

 

[jedraw]

Perhaps you could show us some code related to the combo and text fields? And the table structures could be helpful also.

 

[TheAceMan1]

How are ya SAM453 . . .

[blue]i can get data only in one text field not in all text fields ...[/blue]

Indications are that only one textbox is [blue]bound[/blue] to a field in the forms recordsource. The rest are [blue]unbound[/blue].

To bind an [blue]unbound[/blue] textbox set its [blue]Control Source[/blue] property to the desired field name of the forms recordsource.

So you should have:
[ol][li] Forms [blue]Record Source[/blue] is bound to to a table or query.[/li]
[li]Textboxes are bound.[/li]
[li]Combobox sets the [blue]Filter[/blue] property of the form.[/li][/ol]
Postback the [blue]Row Source[/blue] of the combobox.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see faq219-2884 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]