AXP-SQL2k: No checkboxes in Subform? 
Author Message
 AXP-SQL2k: No checkboxes in Subform?

Hi everyone,
in an adp project with SQL-Server 2000 I created a stored procedure to load
some data into a subform (I have set the DataSource of the Subform to the
stored procedure). In the main form I use a lookup-combobox to get an id.
Within the stored procedure I use a variable (the id from the combobox).

The stp selects some bit-fields an presents them as checkboxes!

The stored procedure works allright. The subform on its own works allright
(checkboxes and all...)
BUT: When I use the main form, there are NO checkboxes in the sub form. The
bit-fields are shown as normal test-fields.
How come? What can I do?

Cheers,
David.



Mon, 25 Jul 2005 17:57:36 GMT
 AXP-SQL2k: No checkboxes in Subform?

Sorry mates,

solved it. I had the wrong datasource for the sub in the main form.

greetz,
David.



Quote:
> Hi everyone,
> in an adp project with SQL-Server 2000 I created a stored procedure to
load
> some data into a subform (I have set the DataSource of the Subform to the
> stored procedure). In the main form I use a lookup-combobox to get an id.
> Within the stored procedure I use a variable (the id from the combobox).

> The stp selects some bit-fields an presents them as checkboxes!

> The stored procedure works allright. The subform on its own works allright
> (checkboxes and all...)
> BUT: When I use the main form, there are NO checkboxes in the sub form.
The
> bit-fields are shown as normal test-fields.
> How come? What can I do?

> Cheers,
> David.



Mon, 25 Jul 2005 18:30:02 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. subform linked on unbound control

2. Serverfilter for Subform not working?

3. Subform SUM([Field]) #Error

4. Checkbox on bound form sets value to -1 for True

5. Get number of records in a subform

6. Error in deleting record in form with subform?

7. Combo box saving to wrong record when entering a subform

8. Linking Form/Subform

9. Checkbox bound to bit field

10. ADO's RecordChangeComplete event is not triggered in subform.

11. many-to-many relationships in forms/subforms

12. unbound subform


 
Powered by phpBB® Forum Software