Blank Form

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

Guest

Hi there

I need some assistance with my command button in my main form. I have a command button with an OnClick macro that opens a smaller form that I want for data entry and for it to be linked to the record that I'm presently on in the main form. When the form opens.. it's blank. I've tried changing most of the properties on the form and nothing works... it's blank

What should my settings be for the small form to appear for data entry and for it to be linked to the present record that I'm on in the main form?

Thanks so much for your hel

Tiffany
 
Ideally this is what I want:
The main driver for the subform is the "Rep Name". When I go to a record on my Main form, I want the subform to display all the records associated with that particular rep... and ALSO to allow for adding another record to the subform for that rep. I cannot figure out how to do that. Help??

Thanks,
Tiffany
 
When the form opens.. it's blank.
Click to expand...

This will happen when the form is based on a Query that a) contains no
records and b) is not updateable. Could you post the SQL view of the
form's Recordsource, and your code?
 
Ideally this is what I want:
The main driver for the subform is the "Rep Name". When I go to a record on my Main form, I want the subform to display all the records associated with that particular rep... and ALSO to allow for adding another record to the subform for that rep. I cannot figure out how to do that. Help??

Thanks,
Tiffany
Click to expand...

What Tables are you using for these forms? What's the Recordsource
property of the main form, and the subform? Forms don't have "drivers"
- they have a Recordsource property which is either a Table, a Query,
or a SQL string (a locally stored query). The Master and Child Link
Fields of the subform filter the subform's query to display only
those records related to the currently selected mainform record.

Perhaps you could post the SQL view of the two recordsources. Open the
Form in design view; view its Properties; click the ... icon by the
Record Source to open a query design window; select View... SQL; and
post the SQL code here.
 
Back
Top