HELP!!! why does my form not show any fields in Form View

[dwrpsych128]

I've been racking my brains on this and I cant seem to understand why Form appears to be fine in Design View but when I click over to Form View none of the fields appear. My Form's Record Source is to a query that I have set up. Below is the SQL. I'm trying to provide this Form to be able to query the database. Not sure if this would be an issue, but most of these databases are accessed via an ODBC connection.:banghead:

SELECT dbo_lwmain.inci_id, dbo_lwmain.offense, dbo_lwmain.date_rept, Trim([streetnbr]) & " " & Trim([street]) AS IncidentLocation, dbo_lwmain.loc_com, PropertyCode_DescLookupTable.PropertyCategory, dbo_prmain.color1, dbo_prmain.make, dbo_prmain.model, dbo_prmain.serialno, dbo_prmain.propdesc, dbo_prmain.prvalue, dbo_prmain.prqnty, dbo_prmain.pecateg
FROM (dbo_LWCHRG INNER JOIN (dbo_prmain INNER JOIN dbo_lwmain ON dbo_prmain.lwmainid = dbo_lwmain.lwmainid) ON dbo_LWCHRG.LWMAINID = dbo_lwmain.lwmainid) INNER JOIN PropertyCode_DescLookupTable ON dbo_prmain.propcode = PropertyCode_DescLookupTable.propcode
WHERE (((dbo_lwmain.inci_id) Like "11CN*") AND ((dbo_lwmain.date_rept) Between [Forms]![Burglary_PropertyInfoQueryForm]![BurglaryDateFrom] And [Forms]![Burglary_PropertyInfoQueryForm]![BurglaryDateTo]) AND ((dbo_LWCHRG.CHRGCNT)=1) AND ((dbo_LWCHRG.UCR_CODE)="220") AND ((dbo_prmain.prstatus)="7"));

 

[pbaldy]

You can see that behavior when the query returns no records and the query (or form) doesn't allow new records.

 

[dwrpsych128]

Ok so I do I go about fixing it. It's so intermitent. It was just working and now doesnt?????

 

[pbaldy]

Presumably it's changing based on the parameters you enter, and whether any records meet them.

 

[dwrpsych128]

So I figured out that when I removed the record source field in the Form Design View the form worked like a charm!! I guess the various fields that I queried were already pointing to go to the form. The form is only being used to search info, not make any modifications to the database. Although, I still dont understand why it would work without specifying a record source.