Displaying only current record in subform

[chris_jolly]

Hey everyone,

I searched to no avail.

I have a query that I am using to input data to a table. I need to display only the current record in the subform, not all the records.

Is there code that will do such a thing?

I have 3 fields in the subform being populated from combo boxes and need to display only the record of the last entries from the combos.

Thanks guys

 

[boblarson]

Do you have a date/time stamp, or some othe method, to determine what the "last" record entered is? If so, you should be able to use the Max expression within grouping to display the latest entry. Of course it will be read-only but that will work.

You could use a filter to also get to the max date/time or other field as well, so that you could just display it but keeping it able to write to.

 

[chris_jolly]

Thanks for the response.

Im not sure the max/date/time method will work. I need the subform to only display the last entry through the combo boxes.

My database can have the same version # (one of the inputs) but have multiple clinkers (cement industry/another input). So I think the max will display all of the verison rather than the last input fromt the combo boxes.

Is there a way I can refer to the current record rather than the max/timestamp?

Would you know the code for the max filter your talking about? I may be able to tweak it to fit my needs

 

[Rabbie]

Access Help is very useful for getting details on how to use something when you dont know all the details

 

[chris_jolly]

Thanks for the help guys. I just set up a one-to-many relationship and that accomplished what I needed.