how do we list the details of main form in subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Using Access 2003 VBA Language Reference how can u list a table based on
queries in a subform
 
I have a main form in which there are several controls like list boxes, combo
box and i have inserted a sub-form too.

What i need is when i select an item from a list box and click on "GO"
button the data related to that selected item should be displayed in the
subform in a tabular format.

could you help me in this regard.

Thanking u in advance
 
What i need is using Select queries and filters, retrieve a subset of Access
records from a table to the the subform.

please help
 
I'm unable to determine whether or not you're attempting to add records or
edit exisitng records. Please excuse my earlier posting, I thought you were
requesting schema info. This might be simplest: back your subform with a
query object (static); add a new record to the Table. Requery the subform
recordsource.
 
I want to add selected records to the subform based on the listbox selection
in the main form.

For eg:
The main form has 2 list boxes and 2 combo boxes.

List1 -> Has parent project ids
List2 -> Has child project ids (this gets populated based on list1 selection)
Combo1 ->Has Metrics like effort rate, Problem rate
Combo2 -> has list of criterias like 10-30%, >30%, etc

So when i select list1, select a metric from the combo and then select the
criteria (Grade) from combo2. I want the list of child projects having effort
rate <10% or greater than 30% to be displayed in the subform.

Please provide me the sample code as i am not very familiar with Access
programming.

Thanks
 
Back
Top